CTX_USER_INDEX_SET_INDEXES

This view displays all the indexes in an index set that belong to the current user. It is queryable by all users.

Column Name	Type	Description
IXX_INDEX_SET_NAME	VARCHAR2(30)	Index set name.
IXX_COLLIST	VARCHAR2(500)	Column list of the index.
IXX_STORAGE	VARCHAR2(500)	Storage clause of the index.