| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 | 
 | 
| 
 | View PDF | 
ALL_APPLY_ERROR displays information about error transactions generated by the apply processes that dequeue events from queues accessible to the current user.
Related View
DBA_APPLY_ERROR displays information about 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) | NOT NULL | Name of the queue at the local database from which the transaction was dequeued | 
| QUEUE_OWNER | VARCHAR2(30) | NOT NULL | 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 this error was created | 
See Also:
"DBA_APPLY_ERROR"