ALL_STREAMS_GLOBAL_RULES
ALL_STREAMS_GLOBAL_RULES displays information about rules.
ALL_STREAMS_GLOBAL_RULES displays information about the following types of rules:
-
Global rules created for the capture processes that enqueue the captured changes into queues accessible to the current user
-
Global rules created for the propagations that have a source queue accessible to the current user
-
Global rules created for the apply processes that dequeue events from queues accessible to the current user
This view does not contain information about rules created using the DBMS_RULE_ADM package.
Related View
DBA_STREAMS_GLOBAL_RULES displays information about the global rules created for all capture processes, propagations, and apply processes in the database.
| Column | Datatype | NULL | Description |
|---|---|---|---|
STREAMS_NAME |
VARCHAR2(128) |
Name of the Replication process or propagation | |
STREAMS_TYPE |
VARCHAR2(11) |
Type of the Replication process or propagation:
|
|
RULE_TYPE |
VARCHAR2(9) |
Type of the rule:
|
|
INCLUDE_TAGGED_LCR |
VARCHAR2(3) |
Indicates whether a redo entry or logical change record (LCR) with a non-NULL tag is considered for capture, propagation, or apply (YES) or not (NO) |
|
SOURCE_DATABASE |
VARCHAR2(128) |
Source database in the rule condition. The rule evaluates to true for a redo entry or logical change record (LCR) only if the redo entry or LCR contains this source database. |
|
RULE_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the rule |
RULE_OWNER |
VARCHAR2(128) |
NOT NULL |
Owner of the rule |
RULE_CONDITION |
VARCHAR2(4000) |
First 4000 bytes of the system-generated rule condition evaluated by the rules engine |
See Also:
-
Oracle AI Database PL/SQL Packages and Types Reference for more information about the
DBMS_RULE_ADMpackage