VIEW: SYS.DBA_APPLY_REPERROR_HANDLERS

Source

View Text - Preformatted

select
  apply_name, schema_name, table_name, source_schema_name, source_table_name,
  error_number,
  decode(method, 1, 'ABEND',
                 2, 'RECORD',
                 3, 'RECORD TRANSACTION',
                 4, 'IGNORE',
                 5, 'RETRY',
                 6, 'RETRY TRANSACTION'),
  max_retries, delay_msecs/10,
  decode(set_by, NULL,'USER',
                    1,'GOLDENGATE')
from sys."_DBA_APPLY_REPERROR_HANDLERS"

View Text - HTML Formatted

SELECT APPLY_NAME
, SCHEMA_NAME
, TABLE_NAME
, SOURCE_SCHEMA_NAME
, SOURCE_TABLE_NAME
, ERROR_NUMBER
, DECODE(METHOD
, 1
, 'ABEND'
, 2
, 'RECORD'
, 3
, 'RECORD TRANSACTION'
, 4
, 'IGNORE'
, 5
, 'RETRY'
, 6
, 'RETRY TRANSACTION')
, MAX_RETRIES
, DELAY_MSECS/10
, DECODE(SET_BY
, NULL
, 'USER'
, 1
, 'GOLDENGATE') FROM SYS."_DBA_APPLY_REPERROR_HANDLERS"