select r.streams_name, decode(r.streams_type, 1, 'CAPTURE',
2, 'PROPAGATION',
3, 'APPLY',
4, 'DEQUEUE', 'UNDEFINED'),
decode(rule_type, 1, 'DML',
2, 'DDL',
3, 'PROCEDURE', 'UNKNOWN'),
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 = 3
SELECT R.STREAMS_NAME
, DECODE(R.STREAMS_TYPE
, 1
, 'CAPTURE'
,
2
, 'PROPAGATION'
,
3
, 'APPLY'
,
4
, 'DEQUEUE'
, 'UNDEFINED')
,
DECODE(RULE_TYPE
, 1
, 'DML'
,
2
, 'DDL'
,
3
, 'PROCEDURE'
, 'UNKNOWN')
,
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 = 3
|
|
|