Oracle: How to get a list of CTXSYS.CONTEXT indices?
USER_INDEXES (and ALL_INDEXES) contains this information:

select index_name, table_name, index_type
from user_indexes
where ityp_owner = 'CTXSYS'
  and ityp_name = 'CONTEXT'