VIEW: SYS.USER_APPLY_ERROR

Source

View Text - Preformatted

select p.apply_name, e.queue_name, e.queue_owner, e.local_transaction_id,
       e.source_database, e.source_transaction_id,
       e.source_commit_scn, e.message_number, e.error_number,
       e.error_message, e.recipient_id, e.recipient_name, e.message_count,
       e.error_creation_time, e.source_commit_position, e.error_type,
       e.source_root_name, e.error_position
  from DBA_APPLY_ERROR e, sys.streams$_apply_process p, sys.user$ u
  where e.apply_name = p.apply_name and p.apply_userid = u.user#
        and u.name = sys_context('USERENV', 'CURRENT_USER')

View Text - HTML Formatted

SELECT P.APPLY_NAME
, E.QUEUE_NAME
, E.QUEUE_OWNER
, E.LOCAL_TRANSACTION_ID
, E.SOURCE_DATABASE
, E.SOURCE_TRANSACTION_ID
, E.SOURCE_COMMIT_SCN
, E.MESSAGE_NUMBER
, E.ERROR_NUMBER
, E.ERROR_MESSAGE
, E.RECIPIENT_ID
, E.RECIPIENT_NAME
, E.MESSAGE_COUNT
, E.ERROR_CREATION_TIME
, E.SOURCE_COMMIT_POSITION
, E.ERROR_TYPE
, E.SOURCE_ROOT_NAME
, E.ERROR_POSITION
FROM DBA_APPLY_ERROR E
, SYS.STREAMS$_APPLY_PROCESS P
, SYS.USER$ U
WHERE E.APPLY_NAME = P.APPLY_NAME
AND P.APPLY_USERID = U.USER#
AND U.NAME = SYS_CONTEXT('USERENV'
, 'CURRENT_USER')