Re: Internal Oracle Error ORA-00600

Hi,

Possible -

1.

ORA-600 [12421] error when the query has AND_EQUAL condition. This was caused by startkey not being included in save area of AND_EQUAL row source and the context is lost when the function call returns.

2.

This problem occurs only on a table that has at leat two indexes, and one of the indexed fields is a char(128) or larger. The workaround is to use varchar or varchar2, or limit field length to a maximum of 127 chars.

Stack trace information from the ORAXXXXX.TRC generated by the ORA-600[12421] in the USER_DUMP_DEST directory.

Best regards,
 Vladimir

In article <3715eaa7.24117048_at_192.86.155.100>,   tkyte_at_us.oracle.com wrote:
> A copy of this was sent to "Merlin Team" <merlin_project_at_free4all.co.uk>
> (if that email address didn't require changing)
> On Thu, 15 Apr 1999 14:04:49 +0100, you wrote:
>
> >Hi,
> >
> >Can anybody spread any further insight into this error the full message is
> >
> >ORA-00600 Internal Error Code
> >Arguments: [12421],[],[],[],[],[],[],[]
> >
> >What can be done to prevent this error reoccuring?
> >
>
> As with all internal errors -- you should contact support with the specifics
of
> what was happening when the error was raised and the corresponding trace
files.
> Even if someone else has the same exact error message as you have above, it
may
> very well be caused by very different things. I see for this error more than
> one thing that can cause it. It will need to be investigated a little more by
> support before the relevant fix can be applied.
>
> >Thanks
> >
> >Paul
> >paul_merlin_at_hotmail.com
> >
>
> Thomas Kyte
> tkyte_at_us.oracle.com
> Oracle Service Industries
> Reston, VA USA
>
> --
> http://govt.us.oracle.com/ -- downloadable utilities
>
> ----------------------------------------------------------------------------
> Opinions are mine and do not necessarily reflect those of Oracle Corporation
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sat Apr 24 1999 - 15:38:15 CDT