[Home] [Help]
[Dependency Information]
TABLE: SYS.CCOL$
Object Details
Object Name: | CCOL$ |
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Storage Details
Tablespace: | SYSTEM |
PCT Free: | 0 |
PCT Used: | 0 |
Indexes
Index |
Type |
Uniqueness |
Tablespace |
Column |
I_CCOL2
|
NORMAL
|
UNIQUE
|
SYSTEM
|
CON#
INTCOL#
|
I_CCOL1
|
NORMAL
|
NONUNIQUE
|
SYSTEM
|
CON#
COL#
|
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
CON# |
NUMBER |
|
Yes |
|
OBJ# |
NUMBER |
|
Yes |
|
COL# |
NUMBER |
|
Yes |
|
POS# |
NUMBER |
|
|
|
INTCOL# |
NUMBER |
|
Yes |
|
SPARE1 |
NUMBER |
|
|
|
SPARE2 |
NUMBER |
|
|
|
SPARE3 |
NUMBER |
|
|
|
SPARE4 |
VARCHAR2 |
(1000) |
|
|
SPARE5 |
VARCHAR2 |
(1000) |
|
|
SPARE6 |
DATE |
|
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT CON#
, OBJ#
, COL#
, POS#
, INTCOL#
, SPARE1
, SPARE2
, SPARE3
, SPARE4
, SPARE5
, SPARE6
FROM SYS.CCOL$;
Dependencies
[top of page]
SYS.CCOL$ does not reference any database object
SYS.CCOL$ is referenced by following:
-
CTXSYS
-
DRI_MOVE_CTXSYS
- show dependent code
-
OLAPSYS
-
ALL$OLAP2UFACT_LEVEL_USES
-
ALL$OLAPMR_FACTTBLKEYMAPS
-
ALL$OLAP_KEY_COLUMN_USES
-
CWM2_OLAP_METADATA_REFRESH
- show dependent code
-
DBA$OLAP2UFACT_LEVEL_USES
-
DBA$OLAPMR_FACTTBLKEYMAPS
-
DBA$OLAP_KEY_COLUMN_USES
-
ODM$OLAP2UFACT_LEVEL_USES
-
SYS
-
ALL_CONS_COLUMNS
-
ALL_LOG_GROUP_COLUMNS
-
DBA_CONS_COLUMNS
-
DBA_LOGSTDBY_NOT_UNIQUE
-
DBA_LOG_GROUP_COLUMNS
-
DBMSOBJG
- show dependent code
-
DBMS_CUBE_ADVISE_SEC
- show dependent code
-
DBMS_DEFERGEN
- show dependent code
-
DBMS_LOGMNR_INTERNAL
- show dependent code
-
DBMS_REDEFINITION_INTERNAL
- show dependent code
-
DBMS_REPCAT_CONF
- show dependent code
-
DBMS_SNAPSHOT_UTL
- show dependent code
-
DBMS_STATS_INTERNAL
- show dependent code
-
DBMS_STATS_INTERNAL
- show dependent code
-
EXU10CCL
-
EXU11IND
-
EXU7CCL
-
EXU7COLNN
-
EXU8CCL
-
EXU8COLNN
-
EXU8OID
-
EXU8REF
-
EXU9CCL
-
EXU9IND
-
IMP8CON
-
IMP9CON
-
INT$DBA_JSON_COLUMNS
-
KU$_CONSTRAINT_COL_VIEW
-
KU$_CONSTRAINT_VIEW
-
KU$_FIND_HIDDEN_CONS_VIEW
-
KU$_FIND_SGC_COLS_VIEW
-
KU$_PKREF_CONSTRAINT_VIEW
-
KU$_SIMPLE_PKREF_COL_VIEW
-
LOGMNR$ALWAYSSUPLOG_PROC
- show dependent code
-
LOGSTDBY_RU_UNSUPPORT_TAB_12_1
-
LOGSTDBY_SUPPORT_TAB_12_1
-
LOGSTDBY_UNSUPPORT_TAB_12_1
-
USER_CONS_COLUMNS
-
USER_LOG_GROUP_COLUMNS
-
_DBA_APPLY_TABLE_COLUMNS_H
-
_DBA_XSTREAM_OUT_ADT_PK_TABLES