SQL下查看ORA错误

SQL下查看ORA错误

例如：

查看ora-12012错误

SQL> !oerr ora 12012

12012, 00000, "error on auto execute of job %s"
// *Cause:  An error was caught while doing an automatic execution of a job.
// *Action: Look at the accompanying errors for details on why the execute
//          failed.

查看ora-44003错误
SQL> !oerr ora 44003
44003, 0000, "invalid SQL name"
// *Document : Yes
// *Cause    : The input parameter string was not a valid simple SQL name.
// *Action   : Check with the DBMS_ASSERT spec to verify that the parameter 

//             string is a valid simple SQL name.

查看ora-600错误

SQL> !oerr ora 600
00600, 00000, "internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]"
// *Cause:  This is the generic internal error number for Oracle program
//         exceptions.  This indicates that a process has encountered an
//         exceptional condition.
// *Action: Report as a bug - the first argument is the internal error number


SQL>