DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: oracle error: ora - 00600 plz suggest

  1. #1
    Join Date
    Jul 2006
    Posts
    96

    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?

  2. #2
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    Which Oracle version?

  3. #3
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    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
    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.

  4. #4
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    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

  5. #5
    Join Date
    Jul 2006
    Posts
    96

    ora-00600 error, oracle 9i version

    Quote Originally Posted by bhattnirav
    Which Oracle version?
    hi it is oracle 9i version

  6. #6
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    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.

  7. #7
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    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
  •  


Click Here to Expand Forum to Full Width