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

VIEW: SYS.CDB_COMPARISON

Object Details
Object Name: CDB_COMPARISON
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Details about the comparison object in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (30) Yes Owner of comparison
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 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) (11)
The time that this row was updated
CON_ID NUMBER

container id
Query Text

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


SELECT OWNER
,      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
,      CON_ID
FROM SYS.CDB_COMPARISON;

Dependencies

[top of page]

SYS.CDB_COMPARISON does not reference any database object

SYS.CDB_COMPARISON is referenced by following:

SchemaPUBLIC
SynonymCDB_COMPARISON