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

Ivo wrote:

> 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Ö.
> calling call entry argument values in
> hex
> location type point (? means dubious
> value)
> -------------------- -------- --------------------
> ----------------------------
> CALL 7601A0 ? 76018C ?
> 76016C ?
> 44 ? EFFFC1B4 ? 0 ?
> PTR_CALL 3 ? 0 ? 0 ? 258 ? 0
> ? 10D0 ?
> CALL 839078 ? 875AAC ?
> 10D0 ? 2 ?
> EFFFC778 ? 833188 ?
> CALL 839078 ? 875AAC ?
> 10D0 ? 2 ?
> 2 ? 0 ?
> CALL 3C045706 ? 3 ? 0 ?
> 0 ? 0 ?
> 0 ?
> CALL EFFFC83C ? 838FA8 ?
> 5 ?
> 83A000 ? 1 ? 3 ?
> CALL 8A680C ? 804D1B74 ?
> 804D0564 ? EFFFD1F0
> ? 0 ?
> 804D1B74 ?
> CALL 8A680C ? 804D0564 ?
> 100 ?
> 839000 ? C ? 1 ?
> CALL 1 ? 0 ? 88271C ?
> 83A000 ?
> 839000 ? 83B400 ?
> CALL 8390EC ? 87BD24 ?
> 83A000 ?
> 83A000 ? 86EF64 ?
> 8A65E0 ?
> CALL EFFFDED8 ? 22 ?
> EFFFDED8 ?
> EFFFF10C ? EFFFDED0
> ? 0 ?
> PTR_CALL 1 ? F ? EFFFF10C ?
> 0 ?
> 83A800 ? 80078648 ?
> PTR_CALL 7DAAC4 ? 1 ?
> EFFFE0E4 ?
> 8390EC ? 80C56A ?
> 79241C ?
> CALL 3B4 ? 840F2C ? 0 ?
> EFFFF10C ?
> 0 ? 0 ?
> CALL 83A150 ? 86AD18 ?
> FBFF ? 0 ?
> 0 ? 83AB28 ?
> PTR_CALL EFFFFCB8 ? 83B860 ?
> 83A800 ?
> 83AB24 ? 0 ? 0 ?
> CALL 7DAA14 ? 0 ?
> EFFFF95C ?
> 8390EC ? 80C53E ?
> 84022C ?
> CALL 3C ? EFFFFA54 ?
> 8390EC ?
> 6C6F6700 ? 0 ?
> EFFFFCE5 ?
> CALL EFFFFCC8 ? 3C ? 4 ?
> EFFFFCB8 ? 84022C ?
> 84022C ?
> CALL 0 ? EFFFFE74 ?
> 851528 ?
> 838C00 ? 0 ? 0 ?
> Any ideas ?
>
> Any help will be greatly apriciated !!!
>
> Thank you.
>
> Ivo Lissev

Do you have backups?

If so use them.

If not ... well you know what I'm thinking.

Daniel A. Morgan Received on Tue Jun 19 2001 - 00:25:44 CDT