CTX_INDEXES

This view displays all indexes that are registered in the Text data dictionary for the current user. It can be queried by CTXSYS.

Column Name	Type	Description
IDX_ID	NUMBER	Internal index id.
IDX_OWNER	VARCHAR2(30)	Owner of index.
IDX_NAME	VARCHAR2(30)	Name of index.
IDX_TABLE_OWNER	VARCHAR2(30)	Owner of table.
IDX_TABLE	VARCHAR2(30)	Table name.
IDX_KEY_NAME	VARCHAR2(256)	Primary key column(s).
IDX_TEXT_NAME	VARCHAR2(30)	Text column name.
IDX_DOCID_COUNT	NUMBER	Number of documents indexed.
IDX_STATUS	VARCHAR2(12)	Status.
IDX_LANGUAGE_COLUMN	VARCHAR2(256)	Name of the language column in base table.
IDX_FORMAT_COLUMN	VARCHAR2(256)	Name of the format column in base table.
IDX_CHARSET_COLUMN	VARCHAR2(256)	Name of the charset column in base table.