Oracle database error code ORA-29864 – analyzing domain indexes marked LOADING/FAILED not supported

Oracle Database Error Code ORA-29864 Description :
analyzing domain indexes marked LOADING/FAILED not supported
Error Cause:
Tried to analyze a domain index which was marked as LOADING or FAILED.

How to Solve :
If the index was marked LOADING, wait till it is marked valid before retrying the analyze. If index was marked FAILED, drop it OR rebuild it and retry the analyze.


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , ,
No Comment Yet   
«
»