ALL_STREAMS_TABLE_RULES

ALL_STREAMS_TABLE_RULES displays information about the following types of rules:

  • Table rules created for the Streams capture processes that enqueue the captured changes into queues accessible to the current user

  • Table rules created for the Streams propagations that have a source queue accessible to the current user

  • Table rules created for the Streams apply processes that dequeue events from queues accessible to the current user

  • Subset rules created for the Streams apply processes that have a source queue accessible to the current user

This view only contains information about rules created using the ADD_TABLE_RULES, ADD_TABLE_PROPAGATION_RULES, or ADD_SUBSET_RULES procedures in the DBMS_STREAMS_ADM package. It does not contain information about rules created using the DBMS_RULE_ADM package.

Related View

DBA_STREAMS_TABLE_RULES displays information about the table rules created for all Streams capture processes, propagations, and apply processes in the database.

Column Datatype NULL Description
STREAMS_NAME VARCHAR2(30)   Name of the Streams process or propagation
STREAMS_TYPE VARCHAR2(12)   Type of the Streams process or propagation:
  • CAPTURE

  • PROPAGATION

  • APPLY

  • DEQUEUE

  • SYNC_CAPTURE

TABLE_OWNER VARCHAR2(30)   Table owner 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 table owner.
TABLE_NAME VARCHAR2(30)   Table name 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 table name.
RULE_TYPE VARCHAR2(7)   Type of the rule:
  • DML

  • DDL

DML_CONDITION VARCHAR2(4000)   Row subsetting condition, if the rule is a subset rule
SUBSETTING_OPERATION VARCHAR2(6)   DML operation for row subsetting in the rule condition, if the rule is a subset rule:
  • INSERT

  • UPDATE

  • DELETE

The rule evaluates to true for a logical change record (LCR) only if the LCR contains this command type after internal transformation.

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(30) NOT NULL Name of the rule
RULE_OWNER VARCHAR2(30) NOT NULL Owner of the rule
RULE_CONDITION VARCHAR2(4000)   First 4000 bytes of the system-generated rule condition evaluated by the rules engine