oracle10g oerr 命令使用

zhulch發表於2007-07-05
..............[@more@]

1 .產看OERR 的位置

$ which oerr
/oradev2/app/oracle/product/10.2.0/bin/oerr

2.看OERR 的使用方法
$ oerr
Usage: oerr facility error

Facility is identified by the prefix string in the error message.
For example, if you get ORA-7300, "ora" is the facility and "7300"
is the error. So you should type "oerr ora 7300".

If you get LCD-111, type "oerr lcd 111", and so on.
$ oerr ora 7300

3.隨便測試一個ORA 的錯誤
$ oerr ora 3200
03200, 00000, "the segment type specification is invalid"
// *Cause: segment type is not TABLE, INDEX, or CLUSTER
// *Action: use a correct segment type
$

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7318139/viewspace-924125/,如需轉載,請註明出處,否則將追究法律責任。

相關文章