select original_capture_name, cloned_capture_name,
original_capture_status, cloned_capture_status,
original_streams_name, cloned_streams_name,
streams_type,
recoverable_script_id, script_status,
action_type, action_threshold,
status, status_update_time,
creation_time,
lag,
job_owner, job_name,
job_state, job_next_run_date,
error_number, error_message
from "_DBA_SXGG_SPLIT_MERGE"
where purpose NOT in ('XStream Out', 'GoldenGate Capture')
SELECT ORIGINAL_CAPTURE_NAME
, CLONED_CAPTURE_NAME
,
ORIGINAL_CAPTURE_STATUS
, CLONED_CAPTURE_STATUS
,
ORIGINAL_STREAMS_NAME
, CLONED_STREAMS_NAME
,
STREAMS_TYPE
,
RECOVERABLE_SCRIPT_ID
, SCRIPT_STATUS
,
ACTION_TYPE
, ACTION_THRESHOLD
,
STATUS
, STATUS_UPDATE_TIME
,
CREATION_TIME
,
LAG
,
JOB_OWNER
, JOB_NAME
,
JOB_STATE
, JOB_NEXT_RUN_DATE
,
ERROR_NUMBER
, ERROR_MESSAGE
FROM "_DBA_SXGG_SPLIT_MERGE"
WHERE PURPOSE NOT IN ('XSTREAM OUT'
, 'GOLDENGATE CAPTURE')
|
|
|