[Home] [Help] [Dependency Information]
Object Name: | DBA_APPLY_CHANGE_HANDLERS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Details about apply change handler
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 |
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;
|
|
|