select r.streams_name, r.streams_type, r.rule_type, r.include_tagged_lcr,
r.source_database, r.rule_name, r.rule_owner, r.rule_condition
from dba_streams_global_rules r, "_ALL_STREAMS_PROCESSES" p, all_rules ar
where r.streams_name = p.streams_name
and r.streams_type = p.streams_type
and ar.rule_owner = r.rule_owner
and ar.rule_name = r.rule_name
SELECT R.STREAMS_NAME
, R.STREAMS_TYPE
, R.RULE_TYPE
, R.INCLUDE_TAGGED_LCR
,
R.SOURCE_DATABASE
, R.RULE_NAME
, R.RULE_OWNER
, R.RULE_CONDITION
FROM DBA_STREAMS_GLOBAL_RULES R
, "_ALL_STREAMS_PROCESSES" P
, ALL_RULES AR
WHERE R.STREAMS_NAME = P.STREAMS_NAME
AND R.STREAMS_TYPE = P.STREAMS_TYPE
AND AR.RULE_OWNER = R.RULE_OWNER
AND AR.RULE_NAME = R.RULE_NAME
|
|
|