eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: SYS.ALL_STREAMS_SCHEMA_RULES

Source

View Text - Preformatted


select sr.streams_name, sr.streams_type, sr.schema_name, sr.rule_type,
       sr.include_tagged_lcr, sr.source_database, sr.rule_name, sr.rule_owner,
       sr.rule_condition
  from dba_streams_schema_rules sr, "_ALL_STREAMS_PROCESSES" p, all_rules r
 where sr.rule_owner = r.rule_owner
   and sr.rule_name = r.rule_name
   and sr.streams_name = p.streams_name
   and sr.streams_type = p.streams_type

View Text - HTML Formatted

SELECT SR.STREAMS_NAME
, SR.STREAMS_TYPE
, SR.SCHEMA_NAME
, SR.RULE_TYPE
, SR.INCLUDE_TAGGED_LCR
, SR.SOURCE_DATABASE
, SR.RULE_NAME
, SR.RULE_OWNER
, SR.RULE_CONDITION
FROM DBA_STREAMS_SCHEMA_RULES SR
, "_ALL_STREAMS_PROCESSES" P
, ALL_RULES R
WHERE SR.RULE_OWNER = R.RULE_OWNER
AND SR.RULE_NAME = R.RULE_NAME
AND SR.STREAMS_NAME = P.STREAMS_NAME
AND SR.STREAMS_TYPE = P.STREAMS_TYPE