Email Alerts
-
Error says temp dir does not have enough space
While installing Oracle 10g on Windows XP I'm getting an error saying the temp dir should be writable or 450 MB of space should be there. I checked my hardware requirements and didn't find the root cause. Ask the Expert
-
Segmentation fault error after 10g installation
I have installed Oracle 10g 64-bit on Linux. When I try to create the database, I get the "Segmentation Fault" error. What do I do? Ask the Expert
-
Invalid stored procedures
When running an application that is connected to an Oracle server/database and trying to add rows or make a call to the DB, I am getting various errors that the stored procedures are invalid. Ask the Expert
-
Oracle expert looks ahead to Database 11g
Oracle Database expert Brian Peasland explains why he has little use for the planned XML upgrades in Database 11g and offers advice for DBAs hoping to get certification. Article
-
ORA-600 error after full backup
I recently upgraded a database from 9i to 10g. My RMAN is also 10g. When I do a full backup, at the end of the backup I get an ORA-600 error. Ask the Expert
-
ORA-01092 error with upgrade
I am trying to upgrade from Oracle 8.1.7 to 9.2.0.6. I changed the dump file destinations in the init file and set the env variables accordingly. When I did startup pfile = '../init.ora' I got the "ORA-01092" error. Ask the Expert
-
Encountered the symbol "ELSE" when expecting one of the following
I am a beginner to Oracle. I am getting this error: "ORA-06550: line 21, column 1: PLS-00103: Encountered the symbol "ELSE" when expecting one of the following:" Ask the Expert
-
Import of .dmp file from 64-bit to 32-bit machine
I am trying to import an Oracle .dmp file generated on a 64-bit machine onto a 32-bit machine, but I am getting an import error. How can I perform the import? Ask the Expert
-
PLS errors after adding columns to table
I altered a table and added two columns. I ran reference type as tablename%rowtype in stored procedures. I got two error messages: "PLS-00302: component 'NUMLABEL' must be declared" and "PLS-00417: unable to resolve 'NUMLABEL' as a column." Ask the Expert
-
Expression is of wrong type
This is a function to check whether the given date is a holiday or not. When I execute this, I am getting an error: "ORA-06552: Statement ignored ORA-06553:PLS-382: Expression is of Wrong Type." What is the problem? Ask the Expert