[Home] [Help] [Dependency Information]
Object Name: | COMPARISON$ |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSAUX |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CMP_UNIQ_IDX1 | NORMAL | UNIQUE | SYSAUX | COMPARISON_ID |
CMP_UNIQ_IDX2 | NORMAL | UNIQUE | SYSAUX | COMPARISON_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMPARISON_ID | NUMBER | Yes | ||
COMPARISON_NAME | VARCHAR2 | (128) | Yes | |
USER# | NUMBER | |||
COMPARISON_MODE | NUMBER | |||
SCHEMA_NAME | VARCHAR2 | (128) | ||
OBJECT_NAME | VARCHAR2 | (128) | ||
OBJECT_TYPE | NUMBER | |||
RMT_SCHEMA_NAME | VARCHAR2 | (128) | ||
RMT_OBJECT_NAME | VARCHAR2 | (128) | ||
RMT_OBJECT_TYPE | NUMBER | |||
DBLINK_NAME | VARCHAR2 | (128) | ||
SCAN_MODE | NUMBER | |||
SCAN_PERCENT | NUMBER | |||
CYL_IDX_VAL | VARCHAR2 | (100) | ||
NULL_VALUE | VARCHAR2 | (4000) | ||
LOC_CONVERGE_TAG | RAW | (2000) | ||
RMT_CONVERGE_TAG | RAW | (2000) | ||
MAX_NUM_BUCKETS | NUMBER | |||
MIN_ROWS_IN_BUCKET | NUMBER | |||
LAST_UPDATE_TIME | TIMESTAMP(6) | (11) | ||
FLAGS | NUMBER | |||
SPARE1 | NUMBER | |||
SPARE2 | NUMBER | |||
SPARE3 | NUMBER | |||
SPARE4 | VARCHAR2 | (1000) |
Cut, paste (and edit) the following text to query this object:
SELECT COMPARISON_ID
, COMPARISON_NAME
, USER#
, COMPARISON_MODE
, SCHEMA_NAME
, OBJECT_NAME
, OBJECT_TYPE
, RMT_SCHEMA_NAME
, RMT_OBJECT_NAME
, RMT_OBJECT_TYPE
, DBLINK_NAME
, SCAN_MODE
, SCAN_PERCENT
, CYL_IDX_VAL
, NULL_VALUE
, LOC_CONVERGE_TAG
, RMT_CONVERGE_TAG
, MAX_NUM_BUCKETS
, MIN_ROWS_IN_BUCKET
, LAST_UPDATE_TIME
, FLAGS
, SPARE1
, SPARE2
, SPARE3
, SPARE4
FROM SYS.COMPARISON$;
SYS.COMPARISON$ does not reference any database object
SYS.COMPARISON$ is referenced by following:
|
|
|