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


TABLE: CTXSYS.DR$INDEX_SET

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

Storage Details
Tablespace: TablespaceCTXD
PCT Free: 10
PCT Used: 40
Primary Key: DRC$IXS_KEY
  1. ColumnIXS_ID
Unique Key: DRC$IXS_NAME
  1. ColumnIXS_NAME
  2. ColumnIXS_OWNER#
Indexes
Index Type Uniqueness Tablespace Column
DRC$IXS_KEY NORMAL UNIQUE TablespaceCTXD ColumnIXS_ID
DRC$IXS_NAME NORMAL UNIQUE TablespaceCTXD ColumnIXS_NAME
ColumnIXS_OWNER#
Columns
Name Datatype Length Mandatory Comments
IXS_ID NUMBER
Yes
IXS_OWNER# NUMBER
Yes
IXS_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT IXS_ID
,      IXS_OWNER#
,      IXS_NAME
FROM CTXSYS.DR$INDEX_SET;

Dependencies

[top of page]

CTXSYS.DR$INDEX_SET does not reference any database object

CTXSYS.DR$INDEX_SET is referenced by following:

SchemaCTXSYS
ViewCTX_INDEX_SETS
ViewCTX_INDEX_SET_INDEXES
ViewCTX_USER_INDEX_SETS
ViewCTX_USER_INDEX_SET_INDEXES
Package BodyDRIIXS - show dependent code