[Home] [Help]
[Dependency Information]
TABLE: SYS.COLTYPE$
Object Details
Object Name: | COLTYPE$ |
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_COLTYPE2
|
NORMAL
|
UNIQUE
|
SYSTEM
|
OBJ#
INTCOL#
|
I_COLTYPE1
|
NORMAL
|
NONUNIQUE
|
SYSTEM
|
OBJ#
COL#
|
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
OBJ# |
NUMBER |
|
Yes |
|
COL# |
NUMBER |
|
Yes |
|
INTCOL# |
NUMBER |
|
Yes |
|
TOID |
RAW |
(16) |
Yes |
|
VERSION# |
NUMBER |
|
Yes |
|
PACKED |
NUMBER |
|
Yes |
|
INTCOLS |
NUMBER |
|
|
|
INTCOL#S |
RAW |
(2000) |
|
|
FLAGS |
NUMBER |
|
|
|
TYPIDCOL# |
NUMBER |
|
|
|
SYNOBJ# |
NUMBER |
|
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT OBJ#
, COL#
, INTCOL#
, TOID
, VERSION#
, PACKED
, INTCOLS
, INTCOL#S
, FLAGS
, TYPIDCOL#
, SYNOBJ#
FROM SYS.COLTYPE$;
Dependencies
[top of page]
SYS.COLTYPE$ does not reference any database object
SYS.COLTYPE$ is referenced by following:
-
CTXSYS
-
DRICON
- show dependent code
-
LBACSYS
-
OLS$POLICY_COLUMNS
-
SYS
-
ALL_NESTED_TABLES
-
ALL_NESTED_TABLE_COLS
-
ALL_OBJECT_TABLES
-
ALL_OBJ_COLATTRS
-
ALL_QUEUE_TABLES
-
ALL_TAB_COLS_V$
-
ALL_TRIGGER_COLS
-
ALL_TSTZ_TAB_COLS
-
ALL_VARRAYS
-
ALL_XML_TABLES
-
ALL_XML_TAB_COLS
-
ALL_XML_VIEWS
-
ALL_XML_VIEW_COLS
-
COL
-
DBA_NESTED_TABLES
-
DBA_NESTED_TABLE_COLS
-
DBA_OBJECT_TABLES
-
DBA_OBJ_COLATTRS
-
DBA_OLDIMAGE_COLUMNS
-
DBA_QUEUE_TABLES
-
DBA_TAB_COLS_V$
-
DBA_TRIGGER_COLS
-
DBA_TSTZ_TAB_COLS
-
DBA_VARRAYS
-
DBA_XML_TABLES
-
DBA_XML_TAB_COLS
-
DBA_XML_VIEWS
-
DBA_XML_VIEW_COLS
-
DBMS_AQADM_SYS
- show dependent code
-
DBMS_LOGMNR_INTERNAL
- show dependent code
-
DBMS_METADATA_UTIL
- show dependent code
-
DBMS_OBJECTS_APPS_UTILS
- show dependent code
-
DBMS_OBJECTS_UTILS
- show dependent code
-
DBMS_PRVTAQIM
- show dependent code
-
DBMS_PRVTAQIP
- show dependent code
-
DBMS_REPCAT_FLA_UTL
- show dependent code
-
DBMS_REPCAT_FLA_UTL
- show dependent code
-
DBMS_REPCAT_MIG_INTERNAL
- show dependent code
-
DBMS_REPCAT_OBJ_UTL
- show dependent code
-
DBMS_REPCAT_UTL2
- show dependent code
-
DBMS_REPCAT_UTL2
- show dependent code
-
DBMS_STATS_INTERNAL
- show dependent code
-
DMP_SEC
- show dependent code
-
EXU10CCL
-
EXU10COE
-
EXU112DLOB
-
EXU81LBSP
-
EXU81NOS
-
EXU81TAB
-
EXU8COE
-
EXU8COL
-
EXU8COL_TTS_UNUSED_COL
-
EXU8COO
-
EXU8CSN
-
EXU8NTB
-
EXU8TYPT
-
EXU8TYPTU
-
EXU9CCL
-
EXU9COE
-
EXU9COO
-
EXU9COO_TTS_UNUSED_COL
-
EXU9INHCOLCONS
-
EXU9LBCP
-
EXU9LBP
-
EXU9LOB
-
EXU9NOS
-
EXU9PLB
-
EXU9TYPT
-
EXU9TYPT2
-
EXU9TYPTU
-
EXU9TYPTU2
-
KU$_10_1_PTAB_STATS_VIEW
-
KU$_10_1_TAB_ONLY_STATS_VIEW
-
KU$_10_2_STRMCOLTYPE_VIEW
-
KU$_ALL_TSLTZ_TAB_COLS
-
KU$_COLTYPE_VIEW
-
KU$_EQNTABLE_DATA_VIEW
-
KU$_HTABLE_DATA_VIEW
-
KU$_HTPART_DATA_VIEW
-
KU$_HTSPART_DATA_VIEW
-
KU$_IOTABLE_DATA_VIEW
-
KU$_IOTPART_DATA_VIEW
-
KU$_NIOTABLE_DATA_VIEW
-
KU$_NTABLE_DATA_VIEW
-
KU$_NTPART_VIEW
-
KU$_NT_PARENT_VIEW
-
KU$_PKREF_CONSTRAINT_VIEW
-
KU$_PTAB_STATS_VIEW
-
KU$_QUEUE_TABLE_VIEW
-
KU$_SIMPLE_PKREF_COL_VIEW
-
KU$_STRMCOLTYPE_VIEW
-
KU$_TABLE_TYPES_VIEW
-
KU$_TAB_ONLY_STATS_VIEW
-
KU$_UNLOAD_METHOD_VIEW
-
LOADER_COL_TYPE
-
LOGMNR_DICT_CACHE
- show dependent code
-
LOGMNR_GTCS_CAT_SUPPORT
-
LOGMNR_TAB_COLS_CAT_SUPPORT
-
LOGSTDBY_RU_UNSUPPORT_TAB_12_1
-
LOGSTDBY_SUPPORT_TAB_12_1
-
LOGSTDBY_UNSUPPORT_TAB_12_1
-
STRADDLING_TS_OBJECTS
-
USER_NESTED_TABLES
-
USER_NESTED_TABLE_COLS
-
USER_OBJECT_TABLES
-
USER_OBJ_COLATTRS
-
USER_OLDIMAGE_COLUMNS
-
USER_QUEUE_TABLES
-
USER_TAB_COLS_V$
-
USER_TRIGGER_COLS
-
USER_TSTZ_TAB_COLS
-
USER_VARRAYS
-
USER_XML_TABLES
-
USER_XML_TAB_COLS
-
USER_XML_VIEWS
-
USER_XML_VIEW_COLS
-
XDB
-
DBMS_XMLSTORAGE_MANAGE
- show dependent code