Re: HELP!! - ORA-00600

It is right in general, but sometimes is possible to rewrite SQL statement and avoid such error. For example, in 8.0.5 hash outer joins often caused ora-600, so changing execution plan may be helpful.

"Mark Wagoner" <mwagoner_at_iac.net> wrote in message news:9881rs$1fud$1_at_genma.iac.net...
> In my experience there is no quick fix for ORA-00600 errors. They are the
> equivalent of a core dump. You might be able to decipher the alert log
 and
> trace files, but you are probably better off opening a TAR with Oracle.
>
> "Adrian Ting" <adrianting_at_post1.com> wrote in message
> news:987pch$paf$1_at_dahlia.singnet.com.sg...
> > Just encountered the following error in the Oracle8.1.6 suddenly.
> >
> > ORA-00600: internal error code, arguments: [15851], [8], [8], [1], [2],
 [],
> > [], []
> >
> > According to OTN, I must report this error to Oracle Customer Support as
 it
> > is an internal error.
> >
> > I need a quick fix for this error. Hope someone can help me out.
> >
> > Adrian
> >
> >
> > ---
> > Outgoing mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.236 / Virus Database: 114 - Release Date: 3/5/01
> >
> >
>
>
Received on Thu Mar 08 2001 - 15:22:00 CET