2.28 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(128)		Owner of the change table
CHANGE_TABLE_NAME	VARCHAR2(128)		Name of the change table
SOURCE_TABLE_OWNER	VARCHAR2(128)		Owner of the source table
SOURCE_TABLE_NAME	VARCHAR2(128)		Name of the source table
HANDLER_NAME	VARCHAR2(128)		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(128)		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

See Also:

• "DBA_APPLY_CHANGE_HANDLERS"

• Oracle Streams Concepts and Administration for more information about change handlers used by an Oracle Streams apply process