oerr linux/unix下oracle查看错误概述
oracle的错误成千上万，我们能记住的可能只有自己工作中会经常碰到的一些错误。oracle提供了一个简单实用的命令oerr来查询错误的简单信息--注意：linux/unix平台下装完oracle就可以直接实用该命令，windows需要实用第三方工具）
oerr命令使用方式如下
# su - oracle
$ oerr ora 01652
01652, 00000, "unable to extend temp segment by %s in tablespace %s"
// *Cause:Failed to allocate an extent of the required number of blocks for
// a temporary segment in the tablespace indicated.
// *Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more
// files to the tablespace indicated.
其他的oracle报错查看方式同上
如使用exp时报错
$ oerr exp 00091
00091, 00000, "Exporting questionable statistics."
// *Cause:Export was able export statistics, but the statistics may not be
// usuable. The statistics are questionable because one or more of
// the following happened during export: a row error occurred, client
// character set or NCHARSET does not match with the server, a query
// clause was specified on export, only certain partitions or
// subpartitions were exported, or a fatal error occurred while
// processing a table.
// *Action: To export non-questionable statistics, change the client character
// set or NCHARSET to match the server, export with no query clause,
// export complete tables. If desired, import parameters can be
// supplied so that only non-questionable statistics will be imported,
// and all questionable statistics will be recalculated.
页:
[1]