Oracle教程 2023-03-23

Oracle 视图 ALL_APPLY_DML_HANDLERS 官方解释，作用，如何使用详细说明

Oracle 视图 ALL_APPLY_DML_HANDLERS 用于显示 Data Guard 环境中已注册的 DML 应用程序处理程序。这种应用程序处理程序允许在由保护程序执行的 Data Guard 复制中检测到数据更改并编写响应程序。

可以使用 ALL_APPLY_DML_HANDLERS 视图中列出的信息来检索已注册的应用程序处理程序，以及处理程序的行为。要查询该视图，可以使用以下句子：

SELECT * FROM all_apply_dml_handlers;

ALL_APPLY_DML_HANDLERS displays information about the DML handlers on the tables accessible to the current user.

Related View

DBA_APPLY_DML_HANDLERS displays information about the DML handlers on all tables in the database.

Column	Datatype	NULL	Description
`OBJECT_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the object on which the DML handler is specified
`OBJECT_NAME`	`VARCHAR2(128)`	`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: `DEFAULT` `INSERT` `UPDATE` `DELETE` `LOB_UPDATE` `ASSEMBLE_LOBS`
`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(128)`		Name of the apply process for the given object
`ASSEMBLE_LOBS`	`VARCHAR2(1)`		Indicates whether LOB assembly is used for LOB columns in logical change records (LCRs) processed by the handler (`Y`) or not (`N`) 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.
`SET_BY`	`VARCHAR2(10)`		Entity that set up the handler. Possible values include: `GOLDENGATE` `USER`