ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE

Hi ,


Today i have got a strange issue which i have never encountered.

I have got an issue saying an INDEX Status is in INPROGRS. The errors is as below.

Error: 

ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE

INDEX_NAME                     STATUS   DOMIDX_STATU DOMIDX
------------------------------ -------- ------------ ------
TEST_INDX                      INPROGRS VALID        VALID


Resolution:

I tried to rebuild the index but didn't helped and not able to drop the index.

SQL> drop index TEST_INDX;
drop index TEST_INDX *
ERROR at line 1:
ORA-29868: cannot issue DDL on a domain index marked as LOADING


DROPPED index with FORCE Option.

SQL> drop index TEST_INDX FORCE;

Index dropped.


ReCREATED the index and got fixed the issue



Thank you !!

SG