ALL_APPLY_ERROR displays information about the error transactions generated by the apply processes that dequeue events 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(22) |
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 event 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 events inside the error transaction | |
ERROR_CREATION_TIME |
DATE |
Time that the error was created |
See Also:
"DBA_APPLY_ERROR"