SELECT comparison_name, scan_id, parent_scan_id, root_scan_id, status,
current_dif_count, initial_dif_count, count_rows,
scan_nulls, last_update_time
FROM dba_comparison_scan
WHERE owner = SYS_CONTEXT('USERENV','CURRENT_USER')
SELECT COMPARISON_NAME
, SCAN_ID
, PARENT_SCAN_ID
, ROOT_SCAN_ID
, STATUS
,
CURRENT_DIF_COUNT
, INITIAL_DIF_COUNT
, COUNT_ROWS
,
SCAN_NULLS
, LAST_UPDATE_TIME
FROM DBA_COMPARISON_SCAN
WHERE OWNER = SYS_CONTEXT('USERENV'
, 'CURRENT_USER')
|
|
|