dba_streams_rules
COLUMN STREAMS_RULE_TYPE HEAD 'Streams|Rule|Level'
FORMAT A7
COLUMN SCHEMA_NAME HEAD 'Schema|Name'
FORMAT A6
COLUMN OBJECT_NAME HEAD 'Object|Name'
FORMAT A11
COLUMN RULE_TYPE HEAD 'Rule|Type'
FORMAT A4
SELECT STREAMS_NAME, STREAMS_TYPE,
RULE_NAME,
RULE_SET_TYPE, TREAMS_RULE_TYPE,
SCHEMA_NAME, BJECT_NAME, RULE_TYPE
FROM DBA_STREAMS_RULES
/
The STREAMS_RULE_TYPE column shows the
level at which the rule operates. The values include schema,
global and table. The object_name is shown if the rule is
for the table level. streams_type shows the type of
client such as Capture or Apply. rule_set_type shows if
the rule is positive or negative. The rule_type column
shows if it is a DML type or DDL type.
The actual rule is shown by the
rule_condition column. The following SQL statement shows the
actual rule condition:
SET LONG 10000
SELECT RULE_NAME, RULE_CONDITION "Current
Rule Condition"
FROM DBA_STREAMS_RULES
/
