ALL_APPLY_REPERROR_HANDLERS

ALL_APPLY_REPERROR_HANDLERS provides details about apply reperror handlers on objects visible to the user.

DBA_APPLY_REPERROR_HANDLERS provides details about apply reperror handlers.

Column Datatype NULL Description
APPLY_NAME VARCHAR2(128) NOT NULL Name of the apply process
OBJECT_OWNER VARCHAR2(128) NOT NULL Owner of the object
OBJECT_NAME VARCHAR2(128) NOT NULL Name of the object
SOURCE_OBJECT_OWNER VARCHAR2(128) NOT NULL Source database owner of the source object
SOURCE_OBJECT_NAME VARCHAR2(128) NOT NULL Source database name of the object
ERROR_NUMBER NUMBER NOT NULL Error number for the handler
METHOD VARCHAR2(18)  

Error handling method:

  • ABEND

  • RECORD

  • IGNORE

  • RETRY

  • RETRY_TRANSACTION

  • RECORD_TRANSACTION
MAX_RETRIES NUMBER   Maximum number of times to retry for the method RETRY and RETRY_TRANSACTION
DELAY_CSECS NUMBER   Number of centiseconds to wait between retries for RETRY and RETRY_TRANSACTION
SET_BY VARCHAR2(10)  

Entity that set up the handler:

  • USER

  • GOLDENGATE

See Also: “DBA_APPLY_REPERROR_HANDLERS”