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_TYPE Foot 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"