Oracle system indexes

We have diagnosed that we have a corrupted index on an Oracle system table.  SQLPlus will not allow us to rebuild the index on the table (because the object is required for a warm boot). Oracle tech support will not help us do the rebuild either. They insist that we dump and reload the entire database.

This problem has kept our system down for 1.5 days. Does anyone know if Oracle has a backdoor way to repair these indexes? I can understand their reluctance to work on system tables, but indexes can always be rebuilt from a table and indexes are their for performance reasons. Missing the index will only slow things down.

Oracle priority support has been terrible throughout this. We have ended up diagnosing the problem and telling them what to do.

Any thoughts our ideas are appreciated.

David Kaiser
Project Manager
State Fund Mutual Insurance Received on Tue Nov 26 1996 - 00:00:00 CET