VIEW: CTXSYS.CTX_USER_INDEX_OBJECTS

Source

View Text - Preformatted

select idx_name  ixo_index_name,
       cla_name  ixo_class,
       obj_name  ixo_object
from dr$index, dr$class, dr$object, dr$index_object
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# = userenv('SCHEMAID')

View Text - HTML Formatted

SELECT IDX_NAME IXO_INDEX_NAME
, CLA_NAME IXO_CLASS
, OBJ_NAME IXO_OBJECT FROM DR$INDEX
, DR$CLASS
, DR$OBJECT
, DR$INDEX_OBJECT 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# = USERENV('SCHEMAID')