eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.USER_COMPARISON

Object Details

Object Name:	USER_COMPARISON
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Details about the user's comparison objects

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
COMPARISON_NAME	VARCHAR2	(128)	Yes	Name of comparison
COMPARISON_MODE	VARCHAR2	(5)		Mode of comparison: TABLE
SCHEMA_NAME	VARCHAR2	(128)		Schema name of local object
OBJECT_NAME	VARCHAR2	(128)		Name of local object
OBJECT_TYPE	VARCHAR2	(17)		Type of local object
REMOTE_SCHEMA_NAME	VARCHAR2	(128)		Schema name of remote object
REMOTE_OBJECT_NAME	VARCHAR2	(128)		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	(100)		Last index column value used in a cyclic scan
NULL_VALUE	VARCHAR2	(4000)		Value to use for null column values
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 number of buckets in a scan
MIN_ROWS_IN_BUCKET	NUMBER			Suggested number of rows in a bucket
LAST_UPDATE_TIME	TIMESTAMP(6)	(11)		The time that this row was updated

Query Text

Cut, paste (and edit) the following text to query this object:


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 SYS.USER_COMPARISON;

Dependencies

[top of page]

SYS.USER_COMPARISON references the following:

SYS: DBA_COMPARISON

SYS.USER_COMPARISON is referenced by following:

PUBLIC: USER_COMPARISON