We are trying to drop a table in Oracle7.3.3.4.0 but get the following error :

ORA-00600: internal error code, arguments: [16515], [D], [2], [82097], [8], [0], [], []


We have tried dropping the user with the cascade option and the tablespace including contents but get the same error when it reaches this table


Any ideas (apart from rebuilding the instance)?

Did you try rebuilding the table ?

We have tried everything we can think of. We can rename the table, we can copy the table, we can export the table and re-import it into another schema and another instance. We just cannot drop the original table, nor analyze it.

Your problem is the actual table, you should create a new one, copy all data, drop old, rename new to be as the old one's name. If you can not so that becuae you need this table 24x7, then try rebuilding all indexes of the table (use rebuild online - for the 24x7).

Tal.

The table is empty and has no indexes. We don't need the table as we have already copied it and the new one is the LIVE version. We are not able to drop the old table as we get ORA-00600 when we try. We want to drop this old table but are unable to

just
Set SORT_AREA_RETAINED_SIZE to the same value as SORT_AREA_SIZE,
or
Do not set SORT_AREA_RETAINED_SIZE to any value

This is going back a few years, but I can recall running into a similar problem in a 7.3.3.4 database. In our case there was a data dictionary corruption that prevented us from dropping the table.

We had to work with Oracle Support to do some 'undocumented, only do at the request of Oracle Support' stuff. If you have support, I'd advise using it. If not, does the mere existance of the table cause any problems? If it is the same problem we had and you can't get support from Oracle, it might be safest to leave it as is.

HTH,
Patrick

Thank you Patrick
I've fixed the problem by truncating sys.hist_head$ which had a lot of rows for this table