[Home] [Help] [Dependency Information]
Object Name: | CDB_APPLY_DML_HANDLERS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Details about the dml handler in all containers
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OBJECT_OWNER | VARCHAR2 | (128) | Yes | Owner of the object |
OBJECT_NAME | VARCHAR2 | (128) | Yes | Name of the object |
OPERATION_NAME | VARCHAR2 | (13) | Name of the DML operation | |
USER_PROCEDURE | VARCHAR2 | (98) | Name of the DML handler specified by the user | |
ERROR_HANDLER | CHAR | (1) | Y if the user procedure is the error handler, N if it is the DML handler | |
APPLY_DATABASE_LINK | VARCHAR2 | (128) | For remote objects, name of database link pointing to remote database | |
APPLY_NAME | VARCHAR2 | (128) | Name of the apply process for the given object | |
ASSEMBLE_LOBS | CHAR | (1) | Y if LOBs should be assembled in DML or error handler | |
HANDLER_NAME | VARCHAR2 | (128) | Name of the apply dml handler, NULL for the ERROR and PROCEDURE handler | |
HANDLER_TYPE | VARCHAR2 | (17) | Type of the apply dml handler | |
SET_BY | VARCHAR2 | (10) | Entity that set up the handler: USER, GOLDENGATE | |
CON_ID | NUMBER | container id |
Cut, paste (and edit) the following text to query this object:
SELECT OBJECT_OWNER
, OBJECT_NAME
, OPERATION_NAME
, USER_PROCEDURE
, ERROR_HANDLER
, APPLY_DATABASE_LINK
, APPLY_NAME
, ASSEMBLE_LOBS
, HANDLER_NAME
, HANDLER_TYPE
, SET_BY
, CON_ID
FROM SYS.CDB_APPLY_DML_HANDLERS;
SYS.CDB_APPLY_DML_HANDLERS does not reference any database object
SYS.CDB_APPLY_DML_HANDLERS is referenced by following:
|
|
|