Good morning!
When trying to insert a line in the database, it gives the error:
The domain index is marked LOADING / FAILED / UNUSABLE
This index marked as failure has the name: "ROLO_IDX"
When trying to rebuild the other error:
RA-29858: An error occurred while executing the ODCIINDEXALTER routine ORA-04063: type body "CTXSYS.TEXTINDEXMETHODS" contains errors 29858. 00000 - "error occurred in the execution of ODCIINDEXALTER routine" * Cause: Failed to successfully execute the ODCIIndexAlter routine. * Action: Check to see if the routine has been coded correctly.
I was in this user CTXSYS and 99% of the views are in error, what do I do?