dba_apply_error

COLUMN APPLY_NAME HEADING 'Apply|Process'                         FORMAT A15
COLUMN SOURCE_DATABASE HEADING 'Source|Database' FORMAT A16
COLUMN SOURCE_COMMIT_SCN HEAD 'Source|CommitSCN' FORMAT 9999999999
COLUMN LOCAL_TRANSACTION_ID HEADING 'Local|Trans ID' FORMAT A12
COLUMN ERROR_NUMBER HEADING 'Error |Number'             FORMAT 9999999
COLUMN ERROR_MESSAGE HEADING 'Error Message'             FORMAT A40
COLUMN MESSAGE_COUNT HEADING 'Events in|ErrTrans' FORMAT 999999

SELECT APPLY_NAME, SOURCE_COMMIT_SCN ,
MESSAGE_NUMBER  , SOURCE_DATABASE,
LOCAL_TRANSACTION_ID, ERROR_NUMBER,
ERROR_MESSAGE, MESSAGE_COUNT
FROM DBA_APPLY_ERROR
order by SOURCE_COMMIT_SCN
/

In the latter part of this chapter, an example has been included on how to display the full details of the error transaction. The full details obtained will help to show the problems involved.

dba_apply_execute

This view displays information about Apply execute actions for the rules in the database.