Oracle教程 2023-02-23

Oracle 视图 ALL_ERRORS_AE 官方解释，作用，如何使用详细说明

：

ALL_ERRORS_AE视图用于显示用户的数据库所有的错误消息，其中包括存储在data dictionary的和可以从Oracle 通知的消息。

该视图由一个表格构成，其列名如下：

OWNER：表示消息产生的拥有者名称

NAME：消息的名称

TYPE：类型，可能是’T’，表示表行为错误或是’U’，表示用户定义错误

LINE：消息定义行数

POSITION：消息定义字符位置

MESSAGE：错误消息

使用ALL_ERRORS_AE视图可以查询数据库中所有的错误消息，从而更好地了解问题的源头，帮助用户解决可能遇到的错误。其使用语句如下：

SELECT * FROM ALL_ERRORS_AE;

ALL_ERRORS_AE describes the current errors on the stored objects (across all editions) accessible to the current user.

Related Views

DBA_ERRORS_AE describes the current errors on all stored objects (across all editions) in the database.
USER_ERRORS_AE describes the current errors on the stored objects (across all editions) owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the object
`NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the object
`TYPE`	`VARCHAR2(12)`		Type of the object: `TYPE` `TYPE BODY` `VIEW` `PROCEDURE` `FUNCTION` `PACKAGE` `PACKAGE BODY` `TRIGGER` `JAVA SOURCE` `JAVA CLASS`
`SEQUENCE`	`NUMBER`	`NOT NULL`	Sequence number (for ordering purposes)
`LINE`	`NUMBER`	`NOT NULL`	Line number at which this error occurred
`POSITION`	`NUMBER`	`NOT NULL`	Position in the line at which this error occurred
`TEXT`	`VARCHAR2(4000)`	`NOT NULL`	Text of the error
`ATTRIBUTE`	`VARCHAR2(9)`		Indicates whether the error is an error (`ERROR`) or a warning (`WARNING`)
`MESSAGE_NUMBER`	`NUMBER`		Numeric error number (without any prefix)
`EDITION_NAME`	`VARCHAR2(128)`		Name of the edition in which the object is actual