Question : I have a query that is selecting some data out of a table. The execution plan shows that […]
Tag: oracle-11g-r2
ORA-01017: invalid username/password; logon denied
Question : I’ve come across the abnormal situation, and can’t understand what happens. I am connecting databases using PL/SQL Developer […]
Eclipse data source explorer not showing Inserted table records (Oracle)
Question : After I installed Oracle database 11g, I went to Eclipse Database Development Perspective and successfully created a new […]
Unable to remove a user in Oracle 11g
Question : I have a streams replication related user in Oracle 11g. I see the user in dba_users table and […]
Is wrapping only possible for package bodies?
Question : I am using oracle 11gR2 database in which I was trying to wrap my scripts. I read the […]
How to make stored procedure with outputs OUT sys_refcursor, OUT varchar2, and OUT number, then use in c#.net app
Question : What is the syntax for a stored procedure that outputs a refcursor, a varchar2, and a number? I […]
RMAN Recovery In Oracle 11g : Backup Database To Tape
Question : On issuing this command: RMAN> backup device type sbt tablespace <tablespace_name>; we are getting the following error: ORA-19554: […]
Does using “qb_name()” hint (query block name) in a query have significant effect on performance?
Question : I’ve just become familiar with the hint “qb_name” (query block name) in Oracle and below you can see […]
How make convincing case to DBA to use Oracle external tables for 500 MB to 5 GB files?
Question : In our data feeds, we have a stack of XML files as well as numerous flat files to […]
Force number precision in a view with Union
Question : I am using Entity Framework and Oracle. Oracle’s ODAC seems to have a known bug where data of […]