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.
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
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")