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
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
|
|
|