ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], []

Running into the this error for last 2 days.

Per the trace file generated, checked the SQL causing the error.

For the tables identified in the trace file,ran the following:

analyze table validate structure cascade;

The above went through fine, but the errors persisted.

Finally, identified all the indexes on the table involved and executed the following:

analyze index validate structure;

The above resolved the ORA-600 errors.

The next step, if the analyze had failed in resolving this, would have been to probably drop and recreate the indexes. I’m sure that would have resolved the error.

Apparently quite a few bugs associated with this error message and LONG columns, luckily, our table didn’t have any LONG columns or SPATIAL indexes

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/563971/viewspace-627121/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/563971/viewspace-627121/