VIEW: SYS.ALL_CAPTURE

Source

View Text - Preformatted

select c."CAPTURE_NAME",c."QUEUE_NAME",c."QUEUE_OWNER",c."RULE_SET_NAME",c."RULE_SET_OWNER",c."CAPTURE_USER",c."START_SCN",c."STATUS",c."CAPTURED_SCN",c."APPLIED_SCN",c."USE_DATABASE_LINK",c."FIRST_SCN",c."SOURCE_DATABASE",c."SOURCE_DBID",c."SOURCE_RESETLOGS_SCN",c."SOURCE_RESETLOGS_TIME",c."LOGMINER_ID",c."NEGATIVE_RULE_SET_NAME",c."NEGATIVE_RULE_SET_OWNER",c."MAX_CHECKPOINT_SCN",c."REQUIRED_CHECKPOINT_SCN",c."LOGFILE_ASSIGNMENT",c."STATUS_CHANGE_TIME",c."ERROR_NUMBER",c."ERROR_MESSAGE",c."VERSION",c."CAPTURE_TYPE",c."LAST_ENQUEUED_SCN",c."CHECKPOINT_RETENTION_TIME",c."START_TIME",c."PURPOSE",c."SOURCE_ROOT_NAME",c."CLIENT_NAME",c."CLIENT_STATUS",c."OLDEST_SCN",c."FILTERED_SCN"
  from dba_capture c, all_queues q
 where c.queue_name = q.name
   and c.queue_owner = q.owner
   and ((c.rule_set_owner is null and c.rule_set_name is null) or
        ((c.rule_set_owner, c.rule_set_name) in
          (select r.rule_set_owner, r.rule_set_name
             from all_rule_sets r)))
   and ((c.negative_rule_set_owner is null and
         c.negative_rule_set_name is null) or
        ((c.negative_rule_set_owner, c.negative_rule_set_name) in
          (select r.rule_set_owner, r.rule_set_name
             from all_rule_sets r)))

View Text - HTML Formatted

SELECT C."CAPTURE_NAME"
, C."QUEUE_NAME"
, C."QUEUE_OWNER"
, C."RULE_SET_NAME"
, C."RULE_SET_OWNER"
, C."CAPTURE_USER"
, C."START_SCN"
, C."STATUS"
, C."CAPTURED_SCN"
, C."APPLIED_SCN"
, C."USE_DATABASE_LINK"
, C."FIRST_SCN"
, C."SOURCE_DATABASE"
, C."SOURCE_DBID"
, C."SOURCE_RESETLOGS_SCN"
, C."SOURCE_RESETLOGS_TIME"
, C."LOGMINER_ID"
, C."NEGATIVE_RULE_SET_NAME"
, C."NEGATIVE_RULE_SET_OWNER"
, C."MAX_CHECKPOINT_SCN"
, C."REQUIRED_CHECKPOINT_SCN"
, C."LOGFILE_ASSIGNMENT"
, C."STATUS_CHANGE_TIME"
, C."ERROR_NUMBER"
, C."ERROR_MESSAGE"
, C."VERSION"
, C."CAPTURE_TYPE"
, C."LAST_ENQUEUED_SCN"
, C."CHECKPOINT_RETENTION_TIME"
, C."START_TIME"
, C."PURPOSE"
, C."SOURCE_ROOT_NAME"
, C."CLIENT_NAME"
, C."CLIENT_STATUS"
, C."OLDEST_SCN"
, C."FILTERED_SCN"
FROM DBA_CAPTURE C
, ALL_QUEUES Q
WHERE C.QUEUE_NAME = Q.NAME
AND C.QUEUE_OWNER = Q.OWNER
AND ((C.RULE_SET_OWNER IS NULL
AND C.RULE_SET_NAME IS NULL) OR ((C.RULE_SET_OWNER
, C.RULE_SET_NAME) IN (SELECT R.RULE_SET_OWNER
, R.RULE_SET_NAME
FROM ALL_RULE_SETS R)))
AND ((C.NEGATIVE_RULE_SET_OWNER IS NULL AND C.NEGATIVE_RULE_SET_NAME IS NULL) OR ((C.NEGATIVE_RULE_SET_OWNER
, C.NEGATIVE_RULE_SET_NAME) IN (SELECT R.RULE_SET_OWNER
, R.RULE_SET_NAME
FROM ALL_RULE_SETS R)))