3.161 ALL_XSTREAM_RULES

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

Related View

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"