VIEW: SYS.USER_COMPARISON

Source

View Text - Preformatted

SELECT comparison_name, comparison_mode,
   schema_name, object_name, object_type,
   remote_schema_name, remote_object_name, remote_object_type, dblink_name,
   scan_mode, scan_percent,
   cyclic_index_value, null_value, local_converge_tag, remote_converge_tag,
   max_num_buckets, min_rows_in_bucket, last_update_time
FROM dba_comparison
WHERE owner = SYS_CONTEXT('USERENV','CURRENT_USER')

View Text - HTML Formatted

SELECT COMPARISON_NAME
, COMPARISON_MODE
, SCHEMA_NAME
, OBJECT_NAME
, OBJECT_TYPE
, REMOTE_SCHEMA_NAME
, REMOTE_OBJECT_NAME
, REMOTE_OBJECT_TYPE
, DBLINK_NAME
, SCAN_MODE
, SCAN_PERCENT
, CYCLIC_INDEX_VALUE
, NULL_VALUE
, LOCAL_CONVERGE_TAG
, REMOTE_CONVERGE_TAG
, MAX_NUM_BUCKETS
, MIN_ROWS_IN_BUCKET
, LAST_UPDATE_TIME FROM DBA_COMPARISON WHERE OWNER = SYS_CONTEXT('USERENV'
, 'CURRENT_USER')