VIEW: SYS.DBA_XSTREAM_RULES

Source

View Text - Preformatted

select
  r1.streams_name, r1.streams_type, r1.streams_rule_type,
  r1.rule_set_owner, r1.rule_set_name, r1.rule_set_type,
  r1.rule_owner, r1.rule_name, r1.rule_type, r1.rule_condition,
  r1.schema_name, r1.object_name, r1.include_tagged_lcr,
  r1.subsetting_operation, r1.dml_condition, r1.source_database,
  r1.original_rule_condition, r1.same_rule_condition, r1.source_root_name,
  dm.source_container_name
from "_DBA_STREAMS_RULES_H2" r1, repl$_dbname_mapping dm
  where ((r1.streams_type = 'CAPTURE') or
         (r1.streams_type = 'APPLY')) and
        ((r1.streams_type, r1.streams_name) IN
      (select 'APPLY', apply_name from dba_apply
       where purpose in ('XStream Out', 'XStream In')
         union
       select 'CAPTURE', capture_name from dba_capture
       where purpose in ('XStream Out'))) and
       r1.source_root_name = dm.source_root_name(+) and
       r1.source_database = dm.source_database_name(+)

View Text - HTML Formatted

SELECT R1.STREAMS_NAME
, R1.STREAMS_TYPE
, R1.STREAMS_RULE_TYPE
, R1.RULE_SET_OWNER
, R1.RULE_SET_NAME
, R1.RULE_SET_TYPE
, R1.RULE_OWNER
, R1.RULE_NAME
, R1.RULE_TYPE
, R1.RULE_CONDITION
, R1.SCHEMA_NAME
, R1.OBJECT_NAME
, R1.INCLUDE_TAGGED_LCR
, R1.SUBSETTING_OPERATION
, R1.DML_CONDITION
, R1.SOURCE_DATABASE
, R1.ORIGINAL_RULE_CONDITION
, R1.SAME_RULE_CONDITION
, R1.SOURCE_ROOT_NAME
, DM.SOURCE_CONTAINER_NAME FROM "_DBA_STREAMS_RULES_H2" R1
, REPL$_DBNAME_MAPPING DM
WHERE ((R1.STREAMS_TYPE = 'CAPTURE') OR (R1.STREAMS_TYPE = 'APPLY')) AND ((R1.STREAMS_TYPE
, R1.STREAMS_NAME) IN (SELECT 'APPLY'
, APPLY_NAME
FROM DBA_APPLY
WHERE PURPOSE IN ('XSTREAM OUT'
, 'XSTREAM IN') UNION SELECT 'CAPTURE'
, CAPTURE_NAME
FROM DBA_CAPTURE
WHERE PURPOSE IN ('XSTREAM OUT'))) AND R1.SOURCE_ROOT_NAME = DM.SOURCE_ROOT_NAME(+) AND R1.SOURCE_DATABASE = DM.SOURCE_DATABASE_NAME(+)