4.160 DBA_COMPARISON

DBA_COMPARISON displays information about all comparison objects in the database.

Related View

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

Column	Datatype	NULL	Description
OWNER	VARCHAR2(128)	NOT NULL	Owner of the comparison
COMPARISON_NAME	VARCHAR2(128)	NOT NULL	Name of the comparison
COMPARISON_MODE	VARCHAR2(5)		Mode of the comparison: TABLE
SCHEMA_NAME	VARCHAR2(128)		Schema name of the local object
OBJECT_NAME	VARCHAR2(128)		Name of the local object
OBJECT_TYPE	VARCHAR2(17)		Type of the local object: TABLE VIEW SYNONYM MATERIALIZED VIEW
REMOTE_SCHEMA_NAME	VARCHAR2(128)		Schema name of the remote object
REMOTE_OBJECT_NAME	VARCHAR2(128)		Name of the remote object
REMOTE_OBJECT_TYPE	VARCHAR2(17)		Type of the remote object: TABLE VIEW SYNONYM MATERIALIZED VIEW
DBLINK_NAME	VARCHAR2(128)		Database link name to the remote database
SCAN_MODE	VARCHAR2(9)		Scan mode of the comparison: FULL FULL RANDOM CYCLIC CUSTOM
SCAN_PERCENT	NUMBER		Scan percent of the 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)		Local Streams tag used while performing converge DMLs
REMOTE_CONVERGE_TAG	RAW(2000)		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_UPDATE_TIME	TIMESTAMP(6)		Time that this row was last updated

See Also:

"USER_COMPARISON"