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

VIEW: SYS.CDB_APPLY_ERROR_MESSAGES

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

Details about individual messages in an error transaction in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
MESSAGE_ID RAW (16)
AQ message ID for a message stored in the AQ exception queue
LOCAL_TRANSACTION_ID VARCHAR2 (22)
Local transaction ID for the error creation transaction
TRANSACTION_MESSAGE_NUMBER NUMBER

Identifier for the message in the transaction that raised an error
ERROR_NUMBER NUMBER

Error number
ERROR_MESSAGE VARCHAR2 (4000)
Error message
SOURCE_OBJECT_OWNER VARCHAR2 (30)
Owner of the object at the source database
SOURCE_OBJECT_NAME VARCHAR2 (30)
Name of the object at the source database
OBJECT_OWNER VARCHAR2 (30)
Owner of the object
OBJECT_NAME VARCHAR2 (30)
Name of the object
PRIMARY_KEY VARCHAR2 (4000)
Primary key information
POSITION RAW (64)
Position information
OPERATION VARCHAR2 (100)
Message operation
MESSAGE CLOB (4000)
Message content
CON_ID NUMBER

container id
Query Text

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


SELECT MESSAGE_ID
,      LOCAL_TRANSACTION_ID
,      TRANSACTION_MESSAGE_NUMBER
,      ERROR_NUMBER
,      ERROR_MESSAGE
,      SOURCE_OBJECT_OWNER
,      SOURCE_OBJECT_NAME
,      OBJECT_OWNER
,      OBJECT_NAME
,      PRIMARY_KEY
,      POSITION
,      OPERATION
,      MESSAGE
,      CON_ID
FROM SYS.CDB_APPLY_ERROR_MESSAGES;

Dependencies

[top of page]

SYS.CDB_APPLY_ERROR_MESSAGES does not reference any database object

SYS.CDB_APPLY_ERROR_MESSAGES is referenced by following:

SchemaPUBLIC
SynonymCDB_APPLY_ERROR_MESSAGES