VIEW: CTXSYS.CTX_USER_INDEX_ERRORS

Source

View Text - Preformatted

select idx_name       err_index_name,
       err_timestamp,
       err_textkey,
       err_text
  from dr$index_error, dr$index
 where idx_id = err_idx_id
   and idx_owner# = userenv('SCHEMAID')

View Text - HTML Formatted

SELECT IDX_NAME ERR_INDEX_NAME
, ERR_TIMESTAMP
, ERR_TEXTKEY
, ERR_TEXT
FROM DR$INDEX_ERROR
, DR$INDEX
WHERE IDX_ID = ERR_IDX_ID
AND IDX_OWNER# = USERENV('SCHEMAID')