DBA_COMPARISON

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_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

Oracle data dictionary views

Oracle dynamic performance views