Oracle教程 2023-02-23

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

本站中文解释

Oracle视图 ALL_GOLDENGATE_RULES 主要用于查询和管理Oracle GoldenGate (OGG) 数据捕获和重放过程中使用的路由规则和参数。

ALL_GOLDENGATE_RULES 包括多个路由规则及其相关参数，其中路由规则可用于管理 OGG 重放过程和数据捕获。通过使用 All_GOLDENGATE_RULES 视图，可以查询已定义的规则的内容和参数，并确定匹配特定条件的应用程序。

使用 All_GOLDENGATE_RULES 视图进行查询有几种不同的方法，最常用的是执行 SELECT 语句来检索所需的视图的全部或部分信息。例如，可以使用以下 SELECT 语句检索 ALL_GOLDENGATE_RULES 视图中所有路由规则的名称：

SELECT RULE_NAME FROM ALL_GOLDENGATE_RULES;

另外，可以使用以下语句检索特定类型的规则：

SELECT * FROM ALL_GOLDENGATE_RULES WHERE RULE_TYPE = ‘Mapping’;

官方英文解释

ALL_GOLDENGATE_RULES displays information about the GoldenGate rules accessible to the current user.

Related View

DBA_GOLDENGATE_RULES displays information about all GoldenGate server rules in the database.

Column	Datatype	NULL	Description
`COMPONENT_NAME`	`VARCHAR2(128)`		Name of the GoldenGate process
`COMPONENT_TYPE`	`VARCHAR2(12)`		Type of the GoldenGate process: `CAPTURE` `APPLY`
`COMPONENT_RULE_TYPE`	`VARCHAR2(9)`		For global, schema or table rules, the GoldenGate type of the rule: `TABLE` `SCHEMA` `GLOBAL`
`RULE_SET_OWNER`	`VARCHAR2(128)`		Owner of the rule set
`RULE_SET_NAME`	`VARCHAR2(128)`		Name of the rule set
`RULE_SET_TYPE`	`CHAR(8)`		Type of the rule set: `POSITIVE` `NEGATIVE`
`RULE_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the rule
`RULE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the rule
`RULE_TYPE`	`VARCHAR2(9)`		For global, schema or table rules, the type of the rule: `DML` `DDL`
`RULE_CONDITION`	`CLOB`		Current rule condition
`SCHEMA_NAME`	`VARCHAR2(128)`		For table and schema rules, the schema name
`OBJECT_NAME`	`VARCHAR2(128)`		For table rules, the table name
`INCLUDE_TAGGED_LCR`	`VARCHAR2(3)`		For global, schema or table rules, indicates whether to include tagged LCRs (`YES`) or not (`NO`)
`SUBSETTING_OPERATION`	`VARCHAR2(6)`		For subset rules, the type of operation: `INSERT` `UPDATE` `DELETE`
`DML_CONDITION`	`VARCHAR2(4000)`		For subset rules, the row subsetting condition
`SOURCE_DATABASE`	`VARCHAR2(128)`		For global, schema or table rules, the name of the database where the LCRs originated
`ORIGINAL_RULE_CONDITION`	`VARCHAR2(4000)`		For rules created by GoldenGate administrative APIs, the original rule condition when the rule was created
`SAME_RULE_CONDITION`	`VARCHAR2(3)`		For rules created by GoldenGate administrative APIs, indicates whether the current rule condition is the same as the original rule condition (`YES`) or not (`NO`)
`SOURCE_ROOT_NAME`	`VARCHAR2(128)`		The global name of the source root database where the transactions originated
`SOURCE_CONTAINER_NAME`	`VARCHAR2(128)`		The container name of the database where the transactions originated

本站中文解释

官方英文解释

相关推荐