select
queue_oid, queue_owner, queue_name, capture#, capture_name,
status, ruleset_owner, ruleset_name, logmnr_sid, predumpscn,
dumpseqbeg, dumpseqend, postdumpscn, flags, start_scn, capture_userid,
spare1, spare2, spare3, use_dblink, first_scn, source_dbname,
spare4, spare5, spare6, spare7, negative_ruleset_owner,
negative_ruleset_name, start_date, end_date, status_change_time,
error_number, error_message, version, start_scn_time, source_root_name
from sys.streams$_capture_process
SELECT
QUEUE_OID
, QUEUE_OWNER
, QUEUE_NAME
, CAPTURE#
, CAPTURE_NAME
,
STATUS
, RULESET_OWNER
, RULESET_NAME
, LOGMNR_SID
, PREDUMPSCN
,
DUMPSEQBEG
, DUMPSEQEND
, POSTDUMPSCN
, FLAGS
, START_SCN
, CAPTURE_USERID
,
SPARE1
, SPARE2
, SPARE3
, USE_DBLINK
, FIRST_SCN
, SOURCE_DBNAME
,
SPARE4
, SPARE5
, SPARE6
, SPARE7
, NEGATIVE_RULESET_OWNER
,
NEGATIVE_RULESET_NAME
, START_DATE
, END_DATE
, STATUS_CHANGE_TIME
,
ERROR_NUMBER
, ERROR_MESSAGE
, VERSION
, START_SCN_TIME
, SOURCE_ROOT_NAME
FROM SYS.STREAMS$_CAPTURE_PROCESS
|
|
|