oerr 命令

錯(cuò)誤代碼分析示例-01

數(shù)據(jù)庫(kù)沒有啟動(dòng)

執(zhí)行語(yǔ)句嘗試觸發(fā)錯(cuò)誤

使用oerr分析錯(cuò)誤代碼

錯(cuò)誤提示

// *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.

大致意思是, 數(shù)據(jù)庫(kù)未啟動(dòng)

啟動(dòng)數(shù)據(jù)庫(kù)

錯(cuò)誤代碼分析示例-02

故意輸入一個(gè)不存在的表

select * from test_example;

使用oerr分析錯(cuò)誤代碼

錯(cuò)誤提示

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

意思是表或視圖不存在