本站中文解释

：

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

See Also:

• “DBA_ERRORS_AE”

• “USER_ERRORS_AE”

---

编辑：一起学习网

标签：消息,错误,视图,定义,用户