[Home] [Help]
select ob."SERVER_NAME",ob."CONNECT_USER",ob."CAPTURE_NAME",ob."SOURCE_DATABASE",ob."CAPTURE_USER",ob."QUEUE_OWNER",ob."QUEUE_NAME",ob."USER_COMMENT",ob."CREATE_DATE",ob."STATUS",ob."COMMITTED_DATA_ONLY",ob."START_SCN",ob."START_TIME",ob."SOURCE_ROOT_NAME"
from dba_xstream_outbound ob, all_apply app
where app.apply_name = ob.server_name
SELECT OB."SERVER_NAME"
, OB."CONNECT_USER"
, OB."CAPTURE_NAME"
, OB."SOURCE_DATABASE"
, OB."CAPTURE_USER"
, OB."QUEUE_OWNER"
, OB."QUEUE_NAME"
, OB."USER_COMMENT"
, OB."CREATE_DATE"
, OB."STATUS"
, OB."COMMITTED_DATA_ONLY"
, OB."START_SCN"
, OB."START_TIME"
, OB."SOURCE_ROOT_NAME"
FROM DBA_XSTREAM_OUTBOUND OB
, ALL_APPLY APP
WHERE APP.APPLY_NAME = OB.SERVER_NAME
|
|
|
|