Couldn't find it on Metalink. Perhaps you should open a TAR for it?
Oracle version? Server version? Is there a trace file? Can you show us the
DDL for the table including its indexes?
> -----Original Message-----
> From: Prem Khanna J [mailto:jprem_at_kssnet.co.jp]
>
> I came across this error in ALRT log file.
>
> ORA-00600 Internal error [12501]
>
> It happened during this SELECT statement and it returned no rows,
> after i dropped an index on FROMPROFNO column.
>
> SELECT NAME,AGE,SEX FROM MSGHISTORY WHERE
> ( MEMNO = 123 AND PROFNO = 456 AND FROMMEMNO = 789 AND
> FROMPROFNO = 910 AND SEX='MALE' AND POINT=1)
> OR
> ( MEMNO = 124 AND PROFNO = 457 AND FROMMEMNO = 789 AND
> FROMPROFNO = 910 AND SEX='MALE' AND POINT=1)
>
> this statement was working fine and was returning rows b4 i
> dropped the index.
>
> as soon as i created an index on FROMPROFNO , it returned rows.
>
> why is it behaving so ?
> whether is there or not , i should be getting the rows.
> but it is not so ?
>
> if there is index , i get the data and if it is not there i
> dont get data.
>
> and what may be reason of ORA 600 [12501] error ?
> when is this error expected ?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jacques Kilchoer
INET: Jacques.Kilchoer_at_quest.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Mon Mar 31 2003 - 12:34:48 CST
