2.151 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 |
---|---|---|---|
|
|
|
Name of the GoldenGate process |
|
|
|
Type of the GoldenGate process:
|
|
|
|
For global, schema or table rules, the GoldenGate type of the rule:
|
|
|
|
Owner of the rule set |
|
|
|
Name of the rule set |
|
|
|
Type of the rule set:
|
|
|
|
Owner of the rule |
|
|
|
Name of the rule |
|
|
|
For global, schema or table rules, the type of the rule:
|
|
|
|
Current rule condition |
|
|
|
For table and schema rules, the schema name |
|
|
|
For table rules, the table name |
|
|
|
For global, schema or table rules, indicates whether to include tagged LCRs ( |
|
|
|
For subset rules, the type of operation:
|
|
|
|
For subset rules, the row subsetting condition |
|
|
|
For global, schema or table rules, the name of the database where the LCRs originated |
|
|
|
For rules created by GoldenGate administrative APIs, the original rule condition when the rule was created |
|
|
|
For rules created by GoldenGate administrative APIs, indicates whether the current rule condition is the same as the original rule condition ( |
|
|
|
The global name of the source root database where the transactions originated |
|
|
|
The container name of the database where the transactions originated |
See Also: