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 |
|---|---|---|---|
|
|
| Owner of the object on which the DML handler is specified |
|
|
| Name of the object on which the DML handler is specified |
|
| Name of the DML operation for which the DML handler is used:
| |
|
| Name of the user-specified DML handler, which handles row logical change records that contain the DML operation in the | |
|
| Indicates whether the DML handler handles only the relevant row logical change records that result in apply errors ( | |
|
| Database link to which changes are applied. If null, then changes are applied to the local database. | |
|
| Name of the apply process for the given object | |
|
| Indicates whether LOB assembly is used for LOB columns in logical change records (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. | |
|
| Entity that set up the handler. Possible values include:
|
See Also:
“DBA_APPLY_DML_HANDLERS”
Oracle Database XStream
Guide for more information about DML handlers in an Oracle XStream environment
编辑：广州鸿名健康科技有限公司
标签：程序,视图,应用程序,可以使用,英文