VIEW: SYS._DBA_XSTREAM_OUTBOUND

Source

View Text - Preformatted

select
  ob.server_name outbound_server, ob.committed_data_only,
  cp.capture_name, cp.status capture_status,
  cp.first_scn, cp.captured_scn, cp.last_enqueued_scn,
  cp.source_database, cp.rule_set_owner capture_ruleset_owner,
  cp.rule_set_name capture_ruleset_name,
  cp.negative_rule_set_owner capture_neg_ruleset_owner,
  cp.negative_rule_set_name capture_neg_ruleset_name, ob.capture_user,
  cp.queue_owner capture_queue_owner, cp.queue_name capture_queue_name,
  ob.status outbound_server_status, ob.connect_user,
  nvl(xc.rule_set_owner, app.ruleset_owner) outbound_ruleset_owner,
  nvl(xc.rule_set_name, app.ruleset_name) outbound_ruleset_name,
  nvl(xc.negative_rule_set_owner, app.negative_ruleset_owner)
    outbound_neg_ruleset_owner,
  nvl(xc.negative_rule_set_name, app.negative_ruleset_name)
     outbound_neg_ruleset_name, cp2.spare5 oldest_scn,
  cp.applied_scn,
  app.spare1, app.spare2, app.spare3
from dba_xstream_outbound ob, dba_capture cp, sys."_DBA_APPLY" app,
  sys.xstream$_server_connection xc, sys."_DBA_CAPTURE" cp2 where
  ob.server_name = app.apply_name and
  ob.capture_name = cp.capture_name (+) and
  cp.capture_name = cp2.capture_name and
  ob.server_name = xc.outbound_server (+)

View Text - HTML Formatted

SELECT OB.SERVER_NAME OUTBOUND_SERVER
, OB.COMMITTED_DATA_ONLY
, CP.CAPTURE_NAME
, CP.STATUS CAPTURE_STATUS
, CP.FIRST_SCN
, CP.CAPTURED_SCN
, CP.LAST_ENQUEUED_SCN
, CP.SOURCE_DATABASE
, CP.RULE_SET_OWNER CAPTURE_RULESET_OWNER
, CP.RULE_SET_NAME CAPTURE_RULESET_NAME
, CP.NEGATIVE_RULE_SET_OWNER CAPTURE_NEG_RULESET_OWNER
, CP.NEGATIVE_RULE_SET_NAME CAPTURE_NEG_RULESET_NAME
, OB.CAPTURE_USER
, CP.QUEUE_OWNER CAPTURE_QUEUE_OWNER
, CP.QUEUE_NAME CAPTURE_QUEUE_NAME
, OB.STATUS OUTBOUND_SERVER_STATUS
, OB.CONNECT_USER
, NVL(XC.RULE_SET_OWNER
, APP.RULESET_OWNER) OUTBOUND_RULESET_OWNER
, NVL(XC.RULE_SET_NAME
, APP.RULESET_NAME) OUTBOUND_RULESET_NAME
, NVL(XC.NEGATIVE_RULE_SET_OWNER
, APP.NEGATIVE_RULESET_OWNER) OUTBOUND_NEG_RULESET_OWNER
, NVL(XC.NEGATIVE_RULE_SET_NAME
, APP.NEGATIVE_RULESET_NAME) OUTBOUND_NEG_RULESET_NAME
, CP2.SPARE5 OLDEST_SCN
, CP.APPLIED_SCN
, APP.SPARE1
, APP.SPARE2
, APP.SPARE3 FROM DBA_XSTREAM_OUTBOUND OB
, DBA_CAPTURE CP
, SYS."_DBA_APPLY" APP
, SYS.XSTREAM$_SERVER_CONNECTION XC
, SYS."_DBA_CAPTURE" CP2 WHERE OB.SERVER_NAME = APP.APPLY_NAME AND OB.CAPTURE_NAME = CP.CAPTURE_NAME (+) AND CP.CAPTURE_NAME = CP2.CAPTURE_NAME AND OB.SERVER_NAME = XC.OUTBOUND_SERVER (+)