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

VIEW: SYS.CDB_APPLY_CHANGE_HANDLERS

Object Details
Object Name: CDB_APPLY_CHANGE_HANDLERS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Details about apply change handler in all containers

[View Source]

Columns
Name Datatype Length Mandatory 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
CON_ID NUMBER

container id
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
,      CON_ID
FROM SYS.CDB_APPLY_CHANGE_HANDLERS;

Dependencies

[top of page]

SYS.CDB_APPLY_CHANGE_HANDLERS does not reference any database object

SYS.CDB_APPLY_CHANGE_HANDLERS is referenced by following:

SchemaPUBLIC
SynonymCDB_APPLY_CHANGE_HANDLERS