select
original_capture_name, cloned_capture_name,
original_queue_owner, original_queue_name,
cloned_queue_owner, cloned_queue_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,
error_number, error_message
from "_DBA_SXGG_SPLIT_MERGE_HIST"
where purpose NOT in ('XStream Out', 'GoldenGate Capture')
SELECT
ORIGINAL_CAPTURE_NAME
, CLONED_CAPTURE_NAME
,
ORIGINAL_QUEUE_OWNER
, ORIGINAL_QUEUE_NAME
,
CLONED_QUEUE_OWNER
, CLONED_QUEUE_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
,
ERROR_NUMBER
, ERROR_MESSAGE
FROM "_DBA_SXGG_SPLIT_MERGE_HIST"
WHERE PURPOSE NOT IN ('XSTREAM OUT'
, 'GOLDENGATE CAPTURE')
|
|
|