eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.DBA_APPLY_CHANGE_HANDLERS

Object Details

Object Name:	DBA_APPLY_CHANGE_HANDLERS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Details about apply change handler

[View Source]

Columns

Name	Datatype	Length	Comments
CHANGE_TABLE_OWNER	VARCHAR2	(128)	Owner of change table
CHANGE_TABLE_NAME	VARCHAR2	(128)	Name of change table
SOURCE_TABLE_OWNER	VARCHAR2	(128)	Owner of source table
SOURCE_TABLE_NAME	VARCHAR2	(128)	Name of source table
HANDLER_NAME	VARCHAR2	(128)	Name of statement-based change handler
CAPTURE_VALUES	VARCHAR2	(3)	Type of value to capture
APPLY_NAME	VARCHAR2	(128)	Name of apply process
OPERATION_NAME	VARCHAR2	(10)	Name of DML operation to which the DML handler is set
CREATION_TIME	TIMESTAMP(6)	(11)	Chang handler creation time
MODIFICATION_TIME	TIMESTAMP(6)	(11)	Chang handler modification time

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CHANGE_TABLE_OWNER
,      CHANGE_TABLE_NAME
,      SOURCE_TABLE_OWNER
,      SOURCE_TABLE_NAME
,      HANDLER_NAME
,      CAPTURE_VALUES
,      APPLY_NAME
,      OPERATION_NAME
,      CREATION_TIME
,      MODIFICATION_TIME
FROM SYS.DBA_APPLY_CHANGE_HANDLERS;

Dependencies

[top of page]

SYS.DBA_APPLY_CHANGE_HANDLERS references the following:

SYS: DBA_APPLY; _DBA_APPLY_CHANGE_HANDLERS

SYS.DBA_APPLY_CHANGE_HANDLERS is referenced by following:

PUBLIC: DBA_APPLY_CHANGE_HANDLERS
SYS: ALL_APPLY_CHANGE_HANDLERS; DBMS_APPLY_ADM_INTERNAL - show dependent code; DBMS_STREAMS_HANDLER_INTERNAL - show dependent code