DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.CDB_ERRORS

Object Details
Object Name: CDB_ERRORS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Current errors on all stored objects in the database in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (30) Yes
NAME VARCHAR2 (30) Yes Name of the object
TYPE VARCHAR2 (12)
Type: "TYPE", "TYPE BODY", "VIEW", "PROCEDURE", "FUNCTION", "PACKAGE", "PACKAGE BODY", "TRIGGER", "JAVA SOURCE" or "JAVA CLASS"
SEQUENCE NUMBER
Yes Sequence number used for ordering purposes
LINE NUMBER
Yes Line number at which this error occurs
POSITION NUMBER
Yes Position in the line at which this error occurs
TEXT VARCHAR2 (4000) Yes Text of the error
ATTRIBUTE VARCHAR2 (9)
MESSAGE_NUMBER NUMBER

CON_ID NUMBER

container id
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      NAME
,      TYPE
,      SEQUENCE
,      LINE
,      POSITION
,      TEXT
,      ATTRIBUTE
,      MESSAGE_NUMBER
,      CON_ID
FROM SYS.CDB_ERRORS;

Dependencies

[top of page]

SYS.CDB_ERRORS does not reference any database object

SYS.CDB_ERRORS is referenced by following:

SchemaPUBLIC
SynonymCDB_ERRORS