-
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?
-
-
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
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
https://metalink.oracle.com/metalink...,0,1,helvetica
https://metalink.oracle.com/metalink...,1,1,helvetica
Might be your case
Regards
-
ora-00600 error, oracle 9i version
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|