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

VIEW: CTXSYS.CTX_INDEXES

Object Details
Object Name: CTX_INDEXES
Object Type: VIEW
Owner: CTXSYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
IDX_ID NUMBER (38) Yes
IDX_OWNER VARCHAR2 (128) Yes
IDX_NAME VARCHAR2 (30) Yes
IDX_TABLE_OWNER VARCHAR2 (128) Yes
IDX_TABLE VARCHAR2 (128) Yes
IDX_KEY_NAME VARCHAR2 (256)
IDX_TEXT_NAME VARCHAR2 (256) Yes
IDX_DOCID_COUNT NUMBER

IDX_STATUS VARCHAR2 (12) Yes
IDX_LANGUAGE_COLUMN VARCHAR2 (256)
IDX_FORMAT_COLUMN VARCHAR2 (256)
IDX_CHARSET_COLUMN VARCHAR2 (256)
IDX_TYPE VARCHAR2 (7)
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_QUERY_STATS_ENABLED VARCHAR2 (3)
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_TEXT_NAME
,      IDX_DOCID_COUNT
,      IDX_STATUS
,      IDX_LANGUAGE_COLUMN
,      IDX_FORMAT_COLUMN
,      IDX_CHARSET_COLUMN
,      IDX_TYPE
,      IDX_SYNC_TYPE
,      IDX_SYNC_MEMORY
,      IDX_SYNC_PARA_DEGREE
,      IDX_SYNC_INTERVAL
,      IDX_SYNC_JOBNAME
,      IDX_QUERY_STATS_ENABLED
FROM CTXSYS.CTX_INDEXES;

Dependencies

[top of page]

CTXSYS.CTX_INDEXES references the following:

SchemaCTXSYS
TableDR$INDEX
SchemaSYS
TableOBJ$
TableUSER$
CTXSYS.CTX_INDEXES is referenced by following:

SchemaAPPS
Package BodyEAM_TEXT_INDEX_PVT - show dependent code
Package BodyEGO_ITEM_TEXT_PVT - show dependent code
Package BodyENG_CHANGE_TEXT_PVT - show dependent code
Package BodyIBC_CONTENT_SYNC_INDEX_PKG - show dependent code
Package BodyJTA_NOTES_IMT_PUB - show dependent code