ALL_APPLY_ERROR
displays information about the error transactions generated by the apply processes that dequeue messages from queues accessible to the current user.
Related Views
DBA_APPLY_ERROR
displays information about the error transactions generated by all apply processes in the database.
USER_APPLY_ERROR
displays information about the error transactions generated by apply processes visible to the current user. This view does not display the SOURCE_ROOT_NAME
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
Name of the apply process at the local database which processed the transaction |
|
|
|
Name of the queue at the local database from which the transaction was dequeued |
|
|
|
Owner of the queue at the local database from which the transaction was dequeued |
|
|
|
Local transaction ID for the error transaction |
|
|
|
Database where the transaction originated |
|
|
|
Original transaction ID at the source database |
|
|
|
Original commit system change number (SCN) for the transaction at the source database |
|
|
|
Identifier for the message in the transaction that raised an error |
|
|
|
Error number of the error raised by the transaction |
|
|
|
Error message of the error raised by the transaction |
|
|
|
User ID of the original user that applied the transaction |
|
|
|
Name of the original user that applied the transaction |
|
|
|
Total number of messages inside the error transaction |
|
|
|
Time that the error was created |
|
|
|
Original commit position for the transaction |
|
|
|
NULL if the apply process can access all of the LCRs in the error transaction. When the
|
|
|
|
The global name of the source root database |
|
|
|
LCR position at which the error occurred |
See Also:
Oracle Database XStream Guide for information on how to display detailed information about apply errors