Re: Cannot drop Oracle table - Oracle 7.3.4 on Solaris 2.7

ivomaya_at_hotmail.com (Ivo) wrote in message news:<abfe1e55.0106181519.48f67515_at_posting.google.com>...
> Hi
>
> I have a serious problem with one of my tables. I have been doing
> "rebuild index" and "compute statistics" on the same table at the same
> time, when ORA-00600 error appeared. After that I tried to access this
> table, but had no success. Dropping the associated indexes did not
> help either. I can not even drop the table as I am getting the
> following error( from the trace file):
>
> ksedmp: internal or fatal error
> ORA-00600: internal error code, arguments: [4304], [15], [284422], [],
> [], [], [], []
> Current SQL statement for this session:
> drop table item_dec2000_X
> ----- Call Stack Trace -----
> No such symbol ïbhÖ.

<SNIP>

> Any ideas ?
>
> Any help will be greatly apriciated !!!
>
> Thank you.
>
> Ivo Lissev

Ivo,
  This sounds a lot like a problem we had. I don't know the cirumstances that led up to it, but we ended up with an unusable table. When we tried to drop it, we got a similar ORA-00600 error. We called Oracle Support and they told us an enrty in the data dictionary got corrupted. They gave us the fix. It seemed painless, and faced with the prospect of doing a full restore anyhow, we gave it a try. It took about two minutes and everything was fixed. I don't have the solution anymore, but would suggest trying Oracle Support. They do help sometimes.

HTH,
Patrick Received on Tue Jun 19 2001 - 08:09:46 CDT