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

TABLE: SYS.ICOL$

Object Details
Object Name: ICOL$
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 0
PCT Used: 0
Indexes
Index Type Uniqueness Tablespace Column
I_ICOL1 NORMAL NONUNIQUE TablespaceSYSTEM ColumnOBJ#
Columns
Name Datatype Length Mandatory Comments
OBJ# NUMBER
Yes
BO# NUMBER
Yes
COL# NUMBER
Yes
POS# NUMBER
Yes
SEGCOL# NUMBER
Yes
SEGCOLLENGTH NUMBER
Yes
OFFSET NUMBER
Yes
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 OBJ#
,      BO#
,      COL#
,      POS#
,      SEGCOL#
,      SEGCOLLENGTH
,      OFFSET
,      INTCOL#
,      SPARE1
,      SPARE2
,      SPARE3
,      SPARE4
,      SPARE5
,      SPARE6
FROM SYS.ICOL$;

Dependencies

[top of page]

SYS.ICOL$ does not reference any database object

SYS.ICOL$ is referenced by following:

SchemaCTXSYS
ProcedureDRI_MOVE_CTXSYS - show dependent code
SchemaSYS
ViewALL_IND_COLUMNS
ViewALL_IND_EXPRESSIONS
ViewDBA_IND_COLUMNS
ViewDBA_IND_EXPRESSIONS
ViewDBA_LOGSTDBY_NOT_UNIQUE
Package BodyDBMSOBJG - show dependent code
Package BodyDBMS_LOGMNR_INTERNAL - show dependent code
Package BodyDBMS_REDEFINITION_INTERNAL - show dependent code
Package BodyDBMS_STATS - show dependent code
Package BodyDBMS_STATS_INTERNAL - show dependent code
PL/SQL PackageDBMS_STATS_INTERNAL - show dependent code
ViewEXU7ICO
ViewEXU8ICO
ViewKU$_FIND_SGI_COLS_VIEW
ViewKU$_INDEX_COL_VIEW
ViewKU$_IND_COL_VIEW
ViewKU$_OIDINDEX_VIEW
ViewLOADER_LOB_INDEX_COL
ViewLOADER_OID_INFO
ProcedureLOGMNR$ALWAYSSUPLOG_PROC - show dependent code
ViewLOGSTDBY_SUPPORT_TAB_11_1
ViewLOGSTDBY_SUPPORT_TAB_11_2
ViewLOGSTDBY_UNSUPPORT_TAB_11_1
ViewLOGSTDBY_UNSUPPORT_TAB_11_2
ViewUSER_IND_COLUMNS
ViewUSER_IND_EXPRESSIONS