Thank you for visiting Spatial DBA - Oracle and ArcSDE.
Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.
====================================================================
Oracle 11gR1
DBA_ERRORS describes the current errors on all stored objects in the database. Its columns are the same as those in ALL_ERRORS.
·
ALL_ERRORS describes the current errors on the stored objects accessible to the current user.
·
USER_ERRORS describes the current errors on the stored objects owned by the current user. This view does not display the OWNER column.
Column
|
Datatype
|
NULL
|
Description
|
OWNER | VARCHAR2(30) | NOT NULL |
Owner of the object
|
NAME | VARCHAR2(30) | NOT NULL |
Name of the object
|
TYPE | VARCHAR2(12) |
Type of the object:
·
VIEW
·
PROCEDURE
·
FUNCTION
·
PACKAGE
·
PACKAGE BODY
·
TRIGGER
·
TYPE
·
TYPE BODY
·
LIBRARY
·
JAVA SOURCE
·
JAVA CLASS
·
DIMENSION | |
SEQUENCE | NUMBER | NOT NULL |
Sequence number (for ordering purposes)
|
LINE | NUMBER | NOT NULL |
Line number at which the error occurred
|
POSITION | NUMBER | NOT NULL |
Position in the line at which the 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)
|
Note:
1.
select * from DBA_ERRORS;
OWNER
|
NAME
|
TYPE
|
SEQUENCE
|
LINE
|
POSITION
|
TEXT
|
ATTRIBUTE
|
MESSAGE_
NUMBER
|
BUS
|
V_FEATURES
|
VIEW
|
1
|
0
|
0
|
ORA-00942: table or view does not exist
|
ERROR
|
0
|
PERFSTAT
|
SP920
|
PACKAGE BODY
|
12
|
198
|
6
|
PL/SQL: Statement ignored
|
ERROR
|
0
|
PERFSTAT
|
SP920
|
PACKAGE BODY
|
11
|
198
|
6
|
PLS-00306: wrong number or types of arguments in call to 'STAT_CHANGES'
|
ERROR
|
306
|
SYS
|
CWM2_OLAP_UTILITY
|
PACKAGE BODY
|
20
|
98
|
23
|
PL/SQL: SQL Statement ignored
|
ERROR
|
0
|
