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

VIEW: SYS.DBA_IND_COLUMNS

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

COLUMNs comprising INDEXes on all TABLEs and CLUSTERs

[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.DBA_IND_COLUMNS;

Dependencies

[top of page]

SYS.DBA_IND_COLUMNS references the following:

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

SchemaPUBLIC
SynonymDBA_IND_COLUMNS
SchemaSYS
Package BodyDBMS_REDEFINITION_INTERNAL - show dependent code
PL/SQL PackageDBMS_REDEFINITION_INTERNAL - show dependent code
Package BodyDBMS_REPCAT_FLA - show dependent code
Package BodyDBMS_REPCAT_MAS - show dependent code
Package BodyDBMS_REPCAT_UTL2 - show dependent code