Google on the ORA-29861 error. It's been too long to remember the details, but the
SDO_GEOMETRY index can get in a strange state where the index is corrupt, so you
can't rebuild it and you can't drop it either. There's a workaround where you hack
the index metadata table, then drop the index; from there you can rebuild it.
- V