DBA_COMPARISON displays details about all comparison objects in the database.

Related View

USER_COMPARISON displays details about comparison objects owned by the current user. This view does not have the OWNER column.

Column Datatype NULL Description
OWNER VARCHAR2(30) NOT NULL Owner of comparison
COMPARISON_MODE VARCHAR2(5)   Mode of comparison: TABLE
SCHEMA_NAME VARCHAR2(30)   Schema name of local object
OBJECT_NAME VARCHAR2(30)   Name of local object
OBJECT_TYPE VARCHAR2(17)   Type of local object
REMOTE_SCHEMA_NAME VARCHAR2(30)   Schema name of remote object
REMOTE_OBJECT_NAME VARCHAR2(30)   Name of remote object
REMOTE_OBJECT_TYPE VARCHAR2(17)   Type of remote object
DBLINK_NAME VARCHAR2(128)   Database link name to remote database
SCAN_MODE VARCHAR2(9)   Scan mode of comparison: FULL
SCAN_PERCENT NUMBER   Scan percent of comparison: applicable to random and cyclic modes
CYCLIC_INDEX_VALUE VARCHAR2(4000)   Last index column value used in a cyclic scan
NULL_VALUE VARCHAR2(4000)   Value to use for null columns
LOCAL_CONVERGE_TAG RAW(2000)   The local Streams tag used while performing converge DMLS
REMOTE_CONVERGE_TAG RAW(2000)   The remote Streams tag used while performing converge DMLS
MAX_NUM_BUCKETS NUMBER   Suggested maximum number of buckets in a scan
MIN_ROWS_IN_BUCKET NUMBER   Suggested minimum number of rows in a bucket
LAST_UPATE_TIME TIMESTAMP(6)   The time that this row was last updated