VIEW: CTXSYS.CTX_INDEX_SET_INDEXES

Source

View Text - Preformatted

select
   u.name            ixx_index_set_owner,
   ixs_name          ixx_index_set_name,
   ixx_collist,
   ixx_storage
from dr$index_set_index, dr$index_set, sys.user$ u
where ixs_owner# = u.user#
  and ixx_ixs_id = ixs_id

View Text - HTML Formatted

SELECT U.NAME IXX_INDEX_SET_OWNER
, IXS_NAME IXX_INDEX_SET_NAME
, IXX_COLLIST
, IXX_STORAGE FROM DR$INDEX_SET_INDEX
, DR$INDEX_SET
, SYS.USER$ U WHERE IXS_OWNER# = U.USER#
AND IXX_IXS_ID = IXS_ID