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

12038
2
03-22-2011 04:16 AM
KyleDixon
Occasional Contributor
I've been getting this error for 3 days. I haven't been able to alter the class at all. We're rebooted all servers, including DB, tried rebuilding indexes, even tried deleting indexes.
0 Kudos
2 Replies
VinceAngelo
Esri Esteemed Contributor
This is a chicken-egg kind of error from Oracle. A shutdown/restart won't change the
metadata which generates a 29861 error. You can often delete the index by using the
FORCE option of "DROP INDEX".

- V
0 Kudos
KyleDixon
Occasional Contributor
I was able to fix it by:
RemoveSpatialIndex_management("Database Connections/ARCSDE.sde/[Offending table]")
AddSpatialIndex_management("Database Connections/ARCSDE.sde/[Offending table]","75000","0","0")
0 Kudos