STREAMS_TYPE

VARCHAR2(12)

Type of the Streams process:

• CAPTURE

• PROPAGATION

• APPLY

• DEQUEUE

• SYNC_CAPTURE

STREAMS_NAME

VARCHAR2(128)

Name of the Streams process

RULE_SET_OWNER

VARCHAR2(128)

Owner of the rule set

RULE_SET_NAME

VARCHAR2(128)

Name of the rule set

RULE_OWNER

VARCHAR2(128)

NOT NULL

Owner of the rule

RULE_NAME

VARCHAR2(128)

NOT NULL

Name of the rule

RULE_CONDITION

CLOB

Current rule condition

RULE_SET_TYPE

CHAR(8)

Type of the rule set:

• POSITIVE

• NEGATIVE

STREAMS_RULE_TYPE

VARCHAR2(9)

For global, schema, or table rules, the type of the rule:

• TABLE

• SCHEMA

• GLOBAL

SCHEMA_NAME

VARCHAR2(128)

For table and schema rules, the schema name

OBJECT_NAME

VARCHAR2(128)

For table rules, the table name

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

INCLUDE_TAGGED_LCR

VARCHAR2(3)

For global, schema, or table rules, indicates whether to include tagged logical change records (LCRs) (YES) or not (NO)

SOURCE_DATABASE

VARCHAR2(128)

For global, schema, or table rules, the global name of the database where the logical change records (LCRs) originated

RULE_TYPE

VARCHAR2(9)

For global, schema, or table rules, the type of the rule:

• DML

• DDL

MESSAGE_TYPE_OWNER

VARCHAR2(128)

For message rules, the owner of the message type

MESSAGE_TYPE_NAME

VARCHAR2(128)

For message rules, the name of the message type

MESSAGE_RULE_VARIABLE

VARCHAR2(128)

For message rules, the name of the variable in the message rule

ORIGINAL_RULE_CONDITION

VARCHAR2(4000)

For rules created by Streams administrative APIs, the original rule condition when the rule was created

SAME_RULE_CONDITION

VARCHAR2(3)

For rules created by Streams administrative APIs, indicates whether the current rule condition is the same as the original rule condition (YES) or not (NO)