Re: internal error 15599

Hello,

Try to see couple of things.
1. which oracle version you are using, if it is below 7.3.3. Then Oracle do not support that version any longer.
2. If it is 7.3.3 or later. Try to disable some of the indexing, and see if it works.
3. I had the same problem some months back, I was using 7.3.2, and we fixed it by disabling one of the indexes and the query did work. Later we reorganized the table correctly and now its not a problem at all. 4. Also try to take the trace dump and send it to the Oracle support. If it is complex, only they can fix this issue.

-Bhavesh

howard lee wrote in message <7or7ki$r2v1_at_news.asiaonline.net>...
>Please help!
>
>i've got a sql which has been running for more than 6 months. it suddenly
>failed after two weeks ago with an error of ORA-0600 : internal error
>[1559]...
>
>the sql consists of three tables, simple join with two columns joining each
>pair of table. The number of rows in the tables range from 500+ to 27000.
>I have tried increasing temp and rbs tablespaces. it still doesn't work.
>could anyone help? please?
>
>thanks
>howard
>
>
Received on Thu Aug 12 1999 - 06:31:05 CDT