DBA_COMPARISON displays details about all comparison objects in the database.
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_NAME |
VARCHAR2(30) |
NOT NULL |
Name 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 |