ORA-29861
I am updating a geometric point and am getting the following errors :
SQL> update meshuser.mps m set m.geometry.sdo_gtype = 2001, m.geometry.sdo_srid = 8307;
update meshuser.mps m set m.geometry.sdo_gtype = 2001, m.geometry.sdo_srid = 8307
*
ERROR at line 1:
ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE
All the indexs I saw were valid ?
Ideas ?
Thanks
Jeff