Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-04 |
|
|
PDF · Mobi · ePub |
ALL_APPLY_DML_HANDLERS
displays information about the DML handlers on the tables accessible to the current user.
DBA_APPLY_DML_HANDLERS
displays information about the DML handlers on all tables in the database.
Column | Datatype | NULL | Description |
---|---|---|---|
OBJECT_OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the object on which the DML handler is specified |
OBJECT_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the object on which the DML handler is specified |
OPERATION_NAME |
VARCHAR2(13) |
Name of the DML operation for which the DML handler is used | |
USER_PROCEDURE |
VARCHAR2(98) |
Name of the user-specified DML handler, which handles row logical change records that contain the DML operation in the OPERATION_NAME column on the object |
|
ERROR_HANDLER |
VARCHAR2(1) |
Indicates whether the DML handler handles only the relevant row logical change records that result in apply errors (Y ) or all relevant row logical change records (N ) |
|
APPLY_DATABASE_LINK |
VARCHAR2(128) |
Database link to which changes are applied. If null, then changes are applied to the local database. | |
APPLY_NAME |
VARCHAR2(30) |
Name of the apply process for the given object | |
ASSEMBLE_LOBS |
VARCHAR2(1) |
If true , then LOB assembly is used for LOB columns in LCRs processed by the handler. LOB assembly combines multiple LCRs for a LOB column resulting from a single row change into one row LCR before passing the LCR to the handler. Database compatibility must be 10.2.0 or higher to use LOB assembly.
If |
See Also:
"DBA_APPLY_DML_HANDLERS"