oracle error: ora - 00600 plz suggest

after entering the following query,
select * from paydetl where party = '123' and
bill_no not in(select distinct bill_no from gkout where
party = '123')

it gives the error
ora-00600 internal error code arguments
[srsale_2], [0], [45], [], [], [], [], []

no rows selected.

here 'gkout' is the valid view.
paydetl is the table.

plz suggest what to do?

Which Oracle version?

Quote:

---

Originally Posted by madhugp

plz suggest what to do?

---

Go to Metalink and initiate a TAR with Oracle.
TAR -now Service Request- will direct you to an ORA-600 troubleshooting tool

Generally you should log a Service request with oracle for ora-600
You may look here
https://metalink.oracle.com/metalink...,0,1,helvetica
https://metalink.oracle.com/metalink...,1,1,helvetica


Might be your case

Regards

Quote:

---

Originally Posted by bhattnirav

Which Oracle version?

---

hi it is oracle 9i version

I have asked about oracle version because I had faced this type of problem in past and solution got from metalink.

At that time the problem is due to view text length.

sorry forgot to wright that oracle version was 7