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

VIEW: SYS.ALL_APPLY_ERROR_MESSAGES

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

Details about individual messages in an error transaction

[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
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
FROM SYS.ALL_APPLY_ERROR_MESSAGES;

Dependencies

[top of page]

SYS.ALL_APPLY_ERROR_MESSAGES references the following:

SchemaSYS
ViewALL_APPLY_ERROR
TableAPPLY$_ERROR_TXN
PL/SQL PackageDBMS_APPLY_ADM - show dependent code
PL/SQL PackageDBMS_STREAMS_LCR_INT - show dependent code
SYS.ALL_APPLY_ERROR_MESSAGES is referenced by following:

SchemaPUBLIC
SynonymALL_APPLY_ERROR_MESSAGES