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_TABLE_RULES

Source

View Text - Preformatted


select tr.streams_name, tr.streams_type, tr.table_owner, tr.table_name,
       tr.rule_type, tr.dml_condition, tr.subsetting_operation,
       tr.include_tagged_lcr, tr.source_database, tr.rule_name,
       tr.rule_owner, tr.rule_condition
  from dba_streams_table_rules tr, "_ALL_STREAMS_PROCESSES" p, all_rules ar
 where tr.rule_owner = ar.rule_owner
   and tr.rule_name = ar.rule_name
   and tr.streams_name = p.streams_name
   and tr.streams_type = p.streams_type

View Text - HTML Formatted

SELECT TR.STREAMS_NAME
, TR.STREAMS_TYPE
, TR.TABLE_OWNER
, TR.TABLE_NAME
, TR.RULE_TYPE
, TR.DML_CONDITION
, TR.SUBSETTING_OPERATION
, TR.INCLUDE_TAGGED_LCR
, TR.SOURCE_DATABASE
, TR.RULE_NAME
, TR.RULE_OWNER
, TR.RULE_CONDITION
FROM DBA_STREAMS_TABLE_RULES TR
, "_ALL_STREAMS_PROCESSES" P
, ALL_RULES AR
WHERE TR.RULE_OWNER = AR.RULE_OWNER
AND TR.RULE_NAME = AR.RULE_NAME
AND TR.STREAMS_NAME = P.STREAMS_NAME
AND TR.STREAMS_TYPE = P.STREAMS_TYPE