Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-23
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

ALL_GOLDENGATE_RULES

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