oerr 命令

错误代码分析示例-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:

意思是表或视图不存在