VIEW: CTXSYS.CTX_USER_INDEX_SET_INDEXES

Source

View Text - Preformatted

select
   ixs_name          ixx_index_set_name,
   ixx_collist,
   ixx_storage
from dr$index_set_index, dr$index_set
where ixx_ixs_id = ixs_id
  and ixs_owner# = userenv('SCHEMAID')

View Text - HTML Formatted

SELECT IXS_NAME IXX_INDEX_SET_NAME
, IXX_COLLIST
, IXX_STORAGE FROM DR$INDEX_SET_INDEX
, DR$INDEX_SET WHERE IXX_IXS_ID = IXS_ID
AND IXS_OWNER# = USERENV('SCHEMAID')