Recreate index because of ORA-600

Hi everyone...
I called Oracle support for an ORA-600 error with arguments 2130, 271, 32 and 3.

I was told that argument 2130 means a corrupt index. I used ANALYZE TABLE schema.tablename VALIDATE STRUCTURE CASCADE; and everything came back valid... no errors.
Then, just to be sure, I analyzed the indexes on the table. All valid. I told the support people this and they are telling me... drop the indexes and rebuild them.
I don't think this is necessarily a bad thing, but... I'm paranoid. There are foreign keys in the indexes and I'm not really keen on screwing this up! I have a full table export with indexes, and a scheme owner export. (And a cold backup on tape!)

Support is not completely sure that this action will "fix" my 600 error anyway...
Any other suggestions would be appreciated! Tnx...
Vick

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jul 08 1999 - 08:40:16 CDT