VIEW: SYS.DBA_COMPARISON_SCAN

Source

View Text - Preformatted

SELECT owner, comparison_name, scan_id, parent_scan_id, root_scan_id,
       decode(status, 1, 'SUC',
                      2, 'BUCKET DIF',
                      3, 'FINAL BUCKET DIF',
                      4, 'ROW DIF'),
       current_dif_count, initial_dif_count,
       count_rows, scan_nulls, last_update_time
FROM "_DBA_COMPARISON_SCAN"

View Text - HTML Formatted

SELECT OWNER
, COMPARISON_NAME
, SCAN_ID
, PARENT_SCAN_ID
, ROOT_SCAN_ID
, DECODE(STATUS
, 1
, 'SUC'
, 2
, 'BUCKET DIF'
, 3
, 'FINAL BUCKET DIF'
, 4
, 'ROW DIF')
, CURRENT_DIF_COUNT
, INITIAL_DIF_COUNT
, COUNT_ROWS
, SCAN_NULLS
, LAST_UPDATE_TIME FROM "_DBA_COMPARISON_SCAN"