| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03  | 
  | 
  | 
PDF · Mobi · ePub | 
ALL_APPLY_ERROR displays information about the error transactions generated by the apply processes that dequeue messages from queues accessible to the current user.
DBA_APPLY_ERROR displays information about the error transactions generated by all apply processes in the database.
| Column | Datatype | NULL | Description | 
|---|---|---|---|
APPLY_NAME | 
VARCHAR2(30) | 
Name of the apply process at the local database which processed the transaction | |
QUEUE_NAME | 
VARCHAR2(30) | 
Name of the queue at the local database from which the transaction was dequeued | |
QUEUE_OWNER | 
VARCHAR2(30) | 
Owner of the queue at the local database from which the transaction was dequeued | |
LOCAL_TRANSACTION_ID | 
VARCHAR2(22) | 
Local transaction ID for the error transaction | |
SOURCE_DATABASE | 
VARCHAR2(128) | 
Database where the transaction originated | |
SOURCE_TRANSACTION_ID | 
VARCHAR2(128) | 
Original transaction ID at the source database | |
SOURCE_COMMIT_SCN | 
NUMBER | 
Original commit system change number (SCN) for the transaction at the source database | |
MESSAGE_NUMBER | 
NUMBER | 
Identifier for the message in the transaction that raised an error | |
ERROR_NUMBER | 
NUMBER | 
Error number of the error raised by the transaction | |
ERROR_MESSAGE | 
VARCHAR2(4000) | 
Error message of the error raised by the transaction | |
RECIPIENT_ID | 
NUMBER | 
User ID of the original user that applied the transaction | |
RECIPIENT_NAME | 
VARCHAR2(30) | 
Name of the original user that applied the transaction | |
MESSAGE_COUNT | 
NUMBER | 
Total number of messages inside the error transaction | |
ERROR_CREATION_TIME | 
DATE | 
Time that the error was created | |
SOURCE_COMMIT_POSITION | 
RAW(64) | 
Original commit position for the transaction | |
ERROR_TYPEFoot 1  | 
VARCHAR2(11) | 
NULL if the apply process can access all of the LCRs in the error transaction. When the ERROR_TYPE is NULL, manage the error transactions using the instructions in Oracle Streams Concepts and Administration.
  | 
Footnote 1 This column is available starting with Oracle Database 11g Release 2 (11.2.0.2).
See Also:
"DBA_APPLY_ERROR"