ALL_APPLY_ERROR_MESSAGES

ALL_APPLY_ERROR_MESSAGES displays information about the individual messages in an error transaction generated by the apply processes that dequeue messages from queues accessible to the current user.

For XStream inbound servers, each message in an error transaction is an LCR.

Note:

  • Messages that were spilled from memory to hard disk do not appear in this view.

  • This view does not contain information related to XStream outbound servers.

Related View

DBA_APPLY_ERROR_MESSAGES displays information about the individual messages in all of the error transactions generated by all apply processes in the database.


Column Datatype NULL Description

MESSAGE_ID

RAW(16)

 

Unique identifier of the message stored in the error queue

LOCAL_TRANSACTION_ID

VARCHAR2(22)

 

Local transaction ID for the error transaction

TRANSACTION_MESSAGE_NUMBER

NUMBER

 

Message number of the message that raised the error. The message number is a sequence number for the messages in the transaction, starting with 1.

ERROR_NUMBER

NUMBER

 

Error number of the error raised by the transaction. The error number is populated only for the LCR that raised the error. This field is NULL for the other LCRs in the transaction.

ERROR_MESSAGE

VARCHAR2(4000)

 

Error message of the error raised by the transaction. The error message is populated only for the LCR that raised the error. This field is NULL for the other LCRs in the transaction.

SOURCE_OBJECT_OWNER

VARCHAR2(128)

 

Owner of the object at the source database

SOURCE_OBJECT_NAME

VARCHAR2(128)

 

Name of the object at the source database

OBJECT_OWNER

VARCHAR2(128)

 

Owner of the target table. This owner can be different than the SOURCE_OBJECT_OWNER due to user-defined transformations that are possible with apply processing.

OBJECT_NAME

VARCHAR2(128)

 

Object name of the target table. This object name can be different than the SOURCE_OBJECT_NAME due to user-defined transformations that are possible with apply processing.

PRIMARY_KEY

VARCHAR2(4000)

 

If this column is populated, it is the primary key of the table row that caused the source transaction to fail at the target.

POSITION

RAW(64)

 

The LCR position

OPERATION

VARCHAR2(100)

 

The DML or DDL operation represented in the LCR

MESSAGE

CLOB

 

The content of the LCR. Content includes column name and value for old and/or new values in DML LCRs. For DDL LCRs, the content is the text of the DDL SQL.


See Also: