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

VIEW: SYS.ALL_IND_COLUMNS

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

COLUMNs comprising INDEXes on accessible TABLES

[View Source]

Columns
Name Datatype Length Mandatory Comments
INDEX_OWNER VARCHAR2 (128) Yes Index owner
INDEX_NAME VARCHAR2 (128) Yes Index name
TABLE_OWNER VARCHAR2 (128) Yes Table or cluster owner
TABLE_NAME VARCHAR2 (128) Yes Table or cluster name
COLUMN_NAME VARCHAR2 (4000)
Column name or attribute of object column
COLUMN_POSITION NUMBER
Yes Position of column or attribute within index
COLUMN_LENGTH NUMBER
Yes Maximum length of the column or attribute, in bytes
CHAR_LENGTH NUMBER

Maximum length of the column or attribute, in characters
DESCEND VARCHAR2 (4)
DESC if this column is sorted in descending order on disk, otherwise ASC
Query Text

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


SELECT INDEX_OWNER
,      INDEX_NAME
,      TABLE_OWNER
,      TABLE_NAME
,      COLUMN_NAME
,      COLUMN_POSITION
,      COLUMN_LENGTH
,      CHAR_LENGTH
,      DESCEND
FROM SYS.ALL_IND_COLUMNS;

Dependencies

[top of page]

SYS.ALL_IND_COLUMNS references the following:

SchemaSYS
TableATTRCOL$
TableCOL$
TableICOL$
TableIND$
TableOBJ$
TableOBJAUTH$
TableUSER$
SYS.ALL_IND_COLUMNS is referenced by following:

SchemaPUBLIC
SynonymALL_IND_COLUMNS
SchemaSYS
Package BodyDBMS_COMPARISON - show dependent code
Package BodyDMP_SEC - show dependent code
Package BodyPRVT_COMPRESSION - show dependent code