[Home] [Help]
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')