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

TABLE: CTXSYS.DR$INDEX_CDI_COLUMN

Object Details
Object Name: DR$INDEX_CDI_COLUMN
Object Type: TABLE
Owner: CTXSYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: Tablespace
PCT Free: 0
PCT Used: 0
Primary Key: SYS_IOT_TOP_486828
  1. ColumnCDI_IDX_ID
  2. ColumnCDI_COLUMN_POSITION
  3. ColumnCDI_COLUMN_NAME
Indexes
Index Type Uniqueness Tablespace Column
SYS_IOT_TOP_486828 IOT - TOP UNIQUE TablespaceCTXD ColumnCDI_IDX_ID
ColumnCDI_COLUMN_POSITION
ColumnCDI_COLUMN_NAME
Columns
Name Datatype Length Mandatory Comments
CDI_IDX_ID NUMBER
Yes
CDI_COLUMN_POSITION NUMBER
Yes
CDI_COLUMN_NAME VARCHAR2 (256) Yes
CDI_COLUMN_TYPE VARCHAR2 (30)
CDI_COLUMN_TYPE# NUMBER

CDI_COLUMN_LENGTH NUMBER

CDI_SECTION_NAME VARCHAR2 (30)
CDI_SECTION_TYPE NUMBER

CDI_SECTION_ID NUMBER

CDI_SORT_ORDER VARCHAR2 (8)
Query Text

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


SELECT CDI_IDX_ID
,      CDI_COLUMN_POSITION
,      CDI_COLUMN_NAME
,      CDI_COLUMN_TYPE
,      CDI_COLUMN_TYPE#
,      CDI_COLUMN_LENGTH
,      CDI_SECTION_NAME
,      CDI_SECTION_TYPE
,      CDI_SECTION_ID
,      CDI_SORT_ORDER
FROM CTXSYS.DR$INDEX_CDI_COLUMN;

Dependencies

[top of page]

CTXSYS.DR$INDEX_CDI_COLUMN does not reference any database object

CTXSYS.DR$INDEX_CDI_COLUMN is referenced by following:

SchemaCTXSYS
ViewCTX_FILTER_BY_COLUMNS
ViewCTX_ORDER_BY_COLUMNS
ViewCTX_USER_FILTER_BY_COLUMNS
ViewCTX_USER_ORDER_BY_COLUMNS
Package BodyDRIEXP - show dependent code
Package BodyDRIIMP - show dependent code
Package BodyDRISGP - show dependent code
Package BodyDRIXMD - show dependent code