CTX_USER_INDEX_ERRORS

This view displays the DML errors and is queryable by all users.

Column Name	Type	Description
ERR_INDEX_NAME	VARCHAR2(30)	Name of index.
ERR_TIMESTAMP	DATE	Time of error.
ERR_TEXTKEY	VARCHAR2(18)	ROWID of errored document or name of errored operation (i.e. ALTER INDEX)
ERR_TEXT	VARCHAR2(4000)	Error text.