2.44 ALL_APPLY_REPERROR_HANDLERS

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

Related View

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