eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: CTXSYS.DR$INDEX

Object Details

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

Storage Details

Tablespace:	CTXD
PCT Free:	10
PCT Used:	40

Primary Key: DRC$IDX_KEY

IDX_ID

Unique Key: DRC$IDX_COLSPEC

IDX_OWNER#
IDX_NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
DRC$IDX_COLSPEC	NORMAL	UNIQUE	CTXD	IDX_OWNER# IDX_NAME
DRC$IDX_KEY	NORMAL	UNIQUE	CTXD	IDX_ID
DRC$IDX_COLUMN	NORMAL	NONUNIQUE	CTXD	IDX_TABLE# IDX_TEXT_NAME

Columns

Name	Datatype	Length	Mandatory
IDX_ID	NUMBER	(38)	Yes
IDX_OWNER#	NUMBER		Yes
IDX_NAME	VARCHAR2	(30)	Yes
IDX_TABLE_OWNER#	NUMBER		Yes
IDX_TABLE#	NUMBER		Yes
IDX_KEY_NAME	VARCHAR2	(256)
IDX_KEY_TYPE	NUMBER
IDX_TEXT_NAME	VARCHAR2	(256)	Yes
IDX_TEXT_TYPE	NUMBER		Yes
IDX_TEXT_LENGTH	NUMBER
IDX_DOCID_COUNT	NUMBER
IDX_STATUS	VARCHAR2	(12)	Yes
IDX_VERSION	NUMBER
IDX_NEXTID	NUMBER
IDX_OPT_TOKEN	VARCHAR2	(64)
IDX_OPT_TYPE	NUMBER
IDX_OPT_COUNT	NUMBER
IDX_LANGUAGE_COLUMN	VARCHAR2	(256)
IDX_FORMAT_COLUMN	VARCHAR2	(256)
IDX_CHARSET_COLUMN	VARCHAR2	(256)
IDX_TYPE	NUMBER		Yes
IDX_OPTION	VARCHAR2	(40)
IDX_SYNC_TYPE	VARCHAR2	(20)
IDX_SYNC_MEMORY	VARCHAR2	(100)
IDX_SYNC_PARA_DEGREE	NUMBER
IDX_SYNC_INTERVAL	VARCHAR2	(2000)
IDX_SYNC_JOBNAME	VARCHAR2	(50)
IDX_SRC_NAME	VARCHAR2	(30)
IDX_SRC_ID	NUMBER
IDX_CONFIG_COLUMN	VARCHAR2	(256)

Query Text

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


SELECT IDX_ID
,      IDX_OWNER#
,      IDX_NAME
,      IDX_TABLE_OWNER#
,      IDX_TABLE#
,      IDX_KEY_NAME
,      IDX_KEY_TYPE
,      IDX_TEXT_NAME
,      IDX_TEXT_TYPE
,      IDX_TEXT_LENGTH
,      IDX_DOCID_COUNT
,      IDX_STATUS
,      IDX_VERSION
,      IDX_NEXTID
,      IDX_OPT_TOKEN
,      IDX_OPT_TYPE
,      IDX_OPT_COUNT
,      IDX_LANGUAGE_COLUMN
,      IDX_FORMAT_COLUMN
,      IDX_CHARSET_COLUMN
,      IDX_TYPE
,      IDX_OPTION
,      IDX_SYNC_TYPE
,      IDX_SYNC_MEMORY
,      IDX_SYNC_PARA_DEGREE
,      IDX_SYNC_INTERVAL
,      IDX_SYNC_JOBNAME
,      IDX_SRC_NAME
,      IDX_SRC_ID
,      IDX_CONFIG_COLUMN
FROM CTXSYS.DR$INDEX;

Dependencies

[top of page]

CTXSYS.DR$INDEX does not reference any database object

CTXSYS.DR$INDEX is referenced by following:

APPS: HZ_DQM_SYNC - show dependent code
CTXSYS: CTX_ALEXER_DICTS; CTX_EXTRACT_POLICIES; CTX_EXTRACT_POLICY_VALUES; CTX_FILTER_BY_COLUMNS; CTX_FILTER_CACHE_STATISTICS; CTX_INDEXES; CTX_INDEX_ERRORS; CTX_INDEX_OBJECTS; CTX_INDEX_PARTITIONS; CTX_INDEX_SECTIONS; CTX_INDEX_SUB_LEXERS; CTX_INDEX_SUB_LEXER_VALUES; CTX_INDEX_VALUES; CTX_ORDER_BY_COLUMNS; CTX_OUTPUT - show dependent code; CTX_PENDING; CTX_USER_EXTRACT_POLICIES; CTX_USER_EXTRACT_POLICY_VALUES; CTX_USER_EXTRACT_RULES; CTX_USER_EXTRACT_STOP_ENTITIES; CTX_USER_FILTER_BY_COLUMNS; CTX_USER_INDEXES; CTX_USER_INDEX_ERRORS; CTX_USER_INDEX_OBJECTS; CTX_USER_INDEX_PARTITIONS; CTX_USER_INDEX_SECTIONS; CTX_USER_INDEX_SUB_LEXERS; CTX_USER_INDEX_SUB_LEXER_VALS; CTX_USER_INDEX_VALUES; CTX_USER_ORDER_BY_COLUMNS; CTX_USER_PENDING; DRIACC - show dependent code; DRIFEAT - show dependent code; DRIIMP - show dependent code; DRIOPT - show dependent code; DRIRIO - show dependent code; DRISGP - show dependent code; DRISPL - show dependent code; DRIUTL - show dependent code; DRIXMD - show dependent code; DRVANL - show dependent code; DRVLSB - show dependent code