oerr 命令

 

Oracle 报错代码分析

错误代码分析示例-01

数据库没有启动

 

执行语句尝试触发错误

 

使用oerr分析错误代码

 

错误提示

// *Cause: Oracle was not started up. Possible causes include the following:
//         - The SGA requires more space than was allocated for it.
//         - The operating-system variable pointing to the instance is
//           improperly defined.
// *Action: Refer to accompanying messages for possible causes and correct
//         the problem mentioned in the other messages.
//         If Oracle has been initialized, then on some operating systems,
//         verify that Oracle was linked correctly. See the platform
//         specific Oracle documentation.

大致意思是, 数据库未启动

启动数据库

 

错误代码分析示例-02

故意输入一个不存在的表

select * from test_example;

 

使用oerr分析错误代码

 

错误提示

00942, 00000, "table or view does not exist"
// *Cause:
// *Action:

意思是表或视图不存在

胜象大百科