VIEW: SYS.DBA_STREAMS_TABLE_RULES

Source

View Text - Preformatted

select r.streams_name, decode(r.streams_type, 1, 'CAPTURE',
                                          2, 'PROPAGATION',
                                          3, 'APPLY',
                                          4, 'DEQUEUE',
                                          5, 'SYNC_CAPTURE',
                                          'UNDEFINED'),
       schema_name, object_name, decode(rule_type, 1, 'DML',
                                                   2, 'DDL', 'UNKNOWN'),
       dml_condition, decode(subsetting_operation, 1, 'INSERT',
                                                   2, 'UPDATE',
                                                   3, 'DELETE'),
       decode(include_tagged_lcr, 0, 'NO',
                                  1, 'YES'),
       source_database, r.rule_name, r.rule_owner, sr.rule_condition
  from "_DBA_STREAMS_RULES" sr, "_DBA_STREAMS_RULES_H" r
 where sr.rule_owner = r.rule_owner and sr.rule_name = r.rule_name
   and object_type = 1

View Text - HTML Formatted

SELECT R.STREAMS_NAME
, DECODE(R.STREAMS_TYPE
, 1
, 'CAPTURE'
, 2
, 'PROPAGATION'
, 3
, 'APPLY'
, 4
, 'DEQUEUE'
, 5
, 'SYNC_CAPTURE'
, 'UNDEFINED')
, SCHEMA_NAME
, OBJECT_NAME
, DECODE(RULE_TYPE
, 1
, 'DML'
, 2
, 'DDL'
, 'UNKNOWN')
, DML_CONDITION
, DECODE(SUBSETTING_OPERATION
, 1
, 'INSERT'
, 2
, 'UPDATE'
, 3
, 'DELETE')
, DECODE(INCLUDE_TAGGED_LCR
, 0
, 'NO'
, 1
, 'YES')
, SOURCE_DATABASE
, R.RULE_NAME
, R.RULE_OWNER
, SR.RULE_CONDITION
FROM "_DBA_STREAMS_RULES" SR
, "_DBA_STREAMS_RULES_H" R
WHERE SR.RULE_OWNER = R.RULE_OWNER
AND SR.RULE_NAME = R.RULE_NAME
AND OBJECT_TYPE = 1