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], , , , , , , 
no rows selected.
here 'gkout' is the valid view.
paydetl is the table.
plz suggest what to do?
Go to Metalink and initiate a TAR with Oracle.
Originally Posted by madhugp
TAR -now Service Request- will direct you to an ORA-600 troubleshooting tool
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Generally you should log a Service request with oracle for ora-600
You may look here
Might be your case
ora-00600 error, oracle 9i version
hi it is oracle 9i version
Originally Posted by bhattnirav
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
Click Here to Expand Forum to Full Width