VIEW: CTXSYS.CTX_INDEX_ERRORS

Source

View Text - Preformatted

select u.name         err_index_owner,
       idx_name       err_index_name,
       err_timestamp,
       err_textkey,
       err_text
  from dr$index_error, dr$index, sys.user$ u
 where idx_id = err_idx_id
   and idx_owner# = u.user#

View Text - HTML Formatted

SELECT U.NAME ERR_INDEX_OWNER
, IDX_NAME ERR_INDEX_NAME
, ERR_TIMESTAMP
, ERR_TEXTKEY
, ERR_TEXT
FROM DR$INDEX_ERROR
, DR$INDEX
, SYS.USER$ U
WHERE IDX_ID = ERR_IDX_ID
AND IDX_OWNER# = U.USER#