VIEW: CTXSYS.CTX_INDEX_OBJECTS

Source

View Text - Preformatted

select u.name    ixo_index_owner,
       idx_name  ixo_index_name,
       cla_name  ixo_class,
       obj_name  ixo_object
from dr$index, dr$class, dr$object, dr$index_object, sys.user$ u
where cla_system = 'N'
  and ixo_cla_id = cla_id
  and ixo_cla_id = obj_cla_id
  and ixo_obj_id = obj_id
  and ixo_idx_id = idx_id
  and idx_owner# = u.user#

View Text - HTML Formatted

SELECT U.NAME IXO_INDEX_OWNER
, IDX_NAME IXO_INDEX_NAME
, CLA_NAME IXO_CLASS
, OBJ_NAME IXO_OBJECT FROM DR$INDEX
, DR$CLASS
, DR$OBJECT
, DR$INDEX_OBJECT
, SYS.USER$ U WHERE CLA_SYSTEM = 'N'
AND IXO_CLA_ID = CLA_ID
AND IXO_CLA_ID = OBJ_CLA_ID
AND IXO_OBJ_ID = OBJ_ID
AND IXO_IDX_ID = IDX_ID
AND IDX_OWNER# = U.USER#