VIEW: CTXSYS.CTX_USER_INDEX_SETS

Source

View Text - Preformatted

select
   ixs_name
from dr$index_set
where ixs_owner# = userenv('SCHEMAID')

View Text - HTML Formatted

SELECT IXS_NAME FROM DR$INDEX_SET WHERE IXS_OWNER# = USERENV('SCHEMAID')