Monday, 6 May 2013

Some common ORA error codes

ORA-00439: feature not enabled: Table compression



ORA-01031: insufficient privileges


ORA-01722: invalid number


ORA-02303: cannot drop or replace a type with type or table dependents


ORA-04044: procedure, function, package, or type is not allowed here


ORA-06502: PL/SQL: numeric or value error string


ORA-12514: TNS:listener does not currently know of service requested in connect descriptor


ORA-12526: TNS:listener: all appropriate instances are in restricted mode


ORA-12560: TNS:protocol adapter error


ORA-12500: TNS:listener failed to start a dedicated server process


ORA-12638: Credential retrieval failed


ORA-01450: Maximum key length (number) exceeded


ORA-14071: invalid option for an index used to enforce a constraint


ORA-25176: storage specification not permitted for primary key


ORA-25194: invalid COMPRESS prefix length value


ORA-12162: TNS: net services name is incorrectly specified


ORA-01555: snapshot too old


ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS_01'


ORA-01950: no privileges on tablespace 'USERS'


ORA-00942: table or view does not exist


ORA-28001: the password has expired


ORA-39070: Unable to open the log file


ORA-00205: error in identifying controlfile, check alert log for more info


ORA-01116: error in opening database file 5


ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


ORA-15110: no diskgroups mounted


No comments:

Post a Comment

Ask your Questions....