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#
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#
|
|
|