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


TABLE: CTXSYS.DR$INDEX_VALUE

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

Storage Details
Tablespace: TablespaceCTXD
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
DRX$IXV_KEY NORMAL NONUNIQUE TablespaceCTXD ColumnIXV_IDX_ID
ColumnIXV_OAT_ID
ColumnIXV_SUB_GROUP
ColumnIXV_SUB_OAT_ID
Columns
Name Datatype Length Mandatory Comments
IXV_IDX_ID NUMBER (38)
IXV_OAT_ID NUMBER (38)
IXV_VALUE VARCHAR2 (500) Yes
IXV_SUB_GROUP NUMBER (38)
IXV_SUB_OAT_ID NUMBER (38)
Query Text

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


SELECT IXV_IDX_ID
,      IXV_OAT_ID
,      IXV_VALUE
,      IXV_SUB_GROUP
,      IXV_SUB_OAT_ID
FROM CTXSYS.DR$INDEX_VALUE;

Dependencies

[top of page]

CTXSYS.DR$INDEX_VALUE does not reference any database object

CTXSYS.DR$INDEX_VALUE is referenced by following:

SchemaCTXSYS
ViewCTX_EXTRACT_POLICY_VALUES
ViewCTX_INDEX_SECTIONS
ViewCTX_INDEX_SUB_LEXERS
ViewCTX_INDEX_SUB_LEXER_VALUES
ViewCTX_INDEX_VALUES
ViewCTX_USER_EXTRACT_POLICY_VALUES
ViewCTX_USER_INDEX_SECTIONS
ViewCTX_USER_INDEX_SUB_LEXERS
ViewCTX_USER_INDEX_SUB_LEXER_VALS
ViewCTX_USER_INDEX_VALUES
Package BodyDRIEXP - show dependent code
Package BodyDRIIMP - show dependent code
Package BodyDRIIXS - show dependent code
Package BodyDRIMLX - show dependent code
Package BodyDRIPREF - show dependent code
Package BodyDRISGP - show dependent code
Package BodyDRISPL - show dependent code
Package BodyDRIUTL - show dependent code
Package BodyDRIXMD - show dependent code