DBA Data[Home] [Help]

VIEW: SYS.DBA_SYNC_CAPTURE

Source

View Text - Preformatted

select cp.capture_name, cp.queue_name, cp.queue_owner, cp.ruleset_name,
       cp.ruleset_owner, u.name
 from "_DBA_CAPTURE" cp, sys.user$ u
 where cp.capture_userid = u.user# (+)
   and bitand(cp.flags,512) = 512
View Text - HTML Formatted

SELECT CP.CAPTURE_NAME
, CP.QUEUE_NAME
, CP.QUEUE_OWNER
, CP.RULESET_NAME
, CP.RULESET_OWNER
, U.NAME
FROM "_DBA_CAPTURE" CP
, SYS.USER$ U
WHERE CP.CAPTURE_USERID = U.USER# (+)
AND BITAND(CP.FLAGS
, 512) = 512