ALL_XSTREAM_RULES

ALL_XSTREAM_RULES displays information about the XStream rules accessible to the current user.

DBA_XSTREAM_RULES displays information about all XStream server rules in the database.

Column Datatype NULL Description
STREAMS_NAME VARCHAR2(128)   Name of the XStream process
STREAMS_TYPE VARCHAR2(12)  

Type of the XStream process:

  • CAPTURE

  • APPLY
STREAMS_RULE_TYPE VARCHAR2(9)  

The XStream 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)  

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)   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)   The global name of the database where the LCRs originated. In a PDB, this is the global name of the PDB.
ORIGINAL_RULE_CONDITION VARCHAR2(4000)   For rules created by the XStream administrative APIs, the original rule condition when the rule was created
SAME_RULE_CONDITION VARCHAR2(3)   For rules created by the XStream 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
SOURCE_CONTAINER_NAME VARCHAR2(128)   The container name of the database where the transactions originated

See Also: “DBA_XSTREAM_RULES”