使用oerr命令查看oracle错误信息

Unix和Linux环境下可以直接使用,windows环境使用需要使用第三方的工具。

$ ./oerr ora 1555
01555, 00000, "snapshot too old: rollback segment number %s with name \"%s\" too small"
// *Cause: rollback records needed by a reader for consistent read are
//         overwritten by other writers
// *Action: If in Automatic Undo Management mode, increase undo_retention
//          setting. Otherwise, use larger rollback segments

参考资料:
Viewing Errors with the oerr Utility
Windows oerr for Oracle

Comments are closed, but trackbacks and pingbacks are open.