Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-14
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

ALL_APPLY_CHANGE_HANDLERS

ALL_APPLY_CHANGE_HANDLERS displays information about the change handlers on the tables accessible to the current user.

Related View

DBA_APPLY_CHANGE_HANDLERS displays information about the change handlers on all tables in the database.

Column Datatype NULL Description
CHANGE_TABLE_OWNER VARCHAR2(30)   Owner of the change table
CHANGE_TABLE_NAME VARCHAR2(30)   Name of the change table
SOURCE_TABLE_OWNER VARCHAR2(30)   Owner of the source table
SOURCE_TABLE_NAME VARCHAR2(30)   Name of the source table
HANDLER_NAME VARCHAR2(30)   Name of the statement-based change handler
CAPTURE_VALUES VARCHAR2(3)   Indicates whether to capture the old (OLD), new (NEW), or both (*) values
APPLY_NAME VARCHAR2(30)   Name of the apply process
OPERATION_NAME VARCHAR2(10)   Name of the DML operation to which the DML handler is set:
  • DEFAULT

  • INSERT

  • UPDATE

  • DELETE

  • LOB_UPDATE

CREATION_TIME TIMESTAMP(6)   Change handler creation time
MODIFICATION_TIME TIMESTAMP(6)   Change handler modification time