VIEW: CTXSYS.CTX_INDEX_SETS

Source

View Text - Preformatted

select
   u.name      ixs_owner,
   ixs_name
from dr$index_set, sys.user$ u
where ixs_owner# = u.user#

View Text - HTML Formatted

SELECT U.NAME IXS_OWNER
, IXS_NAME FROM DR$INDEX_SET
, SYS.USER$ U WHERE IXS_OWNER# = U.USER#