ALL_GOLDENGATE_RULES

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

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(7)  

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(1)   This column is obsolete
RULE_SET_NAME VARCHAR2(1)   This column is obsolete
RULE_SET_TYPE VARCHAR2(1)   This column is obsolete
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 VARCHAR2(1)   This column is obsolete
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(1)   This column is obsolete
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(1)   This column is obsolete
SAME_RULE_CONDITION VARCHAR2(1)   This column is obsolete
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

See Also: “DBA_GOLDENGATE_RULES”