oracle sqlplus下查询错误输出信息

SQL> !oerr ora 00271
00271, 00000, "there are no logs that need archiving"
// *Cause:  An attempt was made to archive the unarchived redo log
//          files manually, but there are no files that need to be archived.
// *Action: No action required.

 

方法：sql>！oerr ora 错误编号

即可查询详细错误信息及建议的操作

SQL> !oerr ora 1
00001, 00000, "unique constraint (%s.%s) violated"
// *Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
//         For Trusted Oracle configured in DBMS MAC mode, you may see
//         this message if a duplicate entry exists at a different level.
// *Action: Either remove the unique restriction or do not insert the key.
.

.

.

.

.