Home » SQL & PL/SQL » SQL & PL/SQL » ORA 600 error (oracle 11.1.0.6)
ORA 600 error [message #396504] Tue, 07 April 2009 00:51 Go to next message
raghud
Messages: 7
Registered: April 2009
Junior Member
ORA-00600: internal error code, arguments: [kkestGetIdxKey: no key for idx!],
[], [], [], [], [], [], []

When raised an issue with the metalink, this is what they have to say:


There is one problem raised for this error, which is fixed in 11.1.0.7 which is generated when the same table is referenced in 2 query blocks and table is part of a cluster. This seems to be a variant to the bug # xxxwhich has been mentioned earlier. That bug deals with hashing operations on a clustered table. It seems that the inline view you're using is treated the same way as a cluster internally, causing the same behavioour to occur.
There are no cluster tables or hashing operations.

the query is


SELECT       mu_id, inv_id, stgr_id, heat_id 
     FROM material_unit 
     WHERE mu_id in 
         (SELECT      mu_id FROM 
             (SELECT   
                 mu.mu_id, mu.inv_id,
                 mu.stgr_id, mu.heat_id 
                 FROM
                 material_unit mu,
                 plant_configuration_item pci,
                 production_resource pr,
                 oper_res ors,
                 route_operation ro    WHERE mu.inv_id    = pci.inv_id
                 AND pci.pcfg_id    = 22
                 AND pci.res_id    = pr.res_id
                 AND ors.agres_id = pr.agres_id
                 AND ors.oper_id = ro.oper_id
                 AND ro.route_id = 'R1'
                 AND ro.step_number = 1
             )  )  
         AND      0.010000  < (SELECT to_number(chr_value) FROM material_unit_characteristic WHERE mu_id='SL18' AND mu_set = 1
                 AND chr_id = 'AVWGHT')



I am struck with this and unable to move forward. Please let me know if I need to provide any more information.

Is there any alternative to remove the inline view and rewrite the sql? Please help

[Updated on: Tue, 07 April 2009 01:22] by Moderator

Report message to a moderator

Re: ORA 600 error [message #396513 is a reply to message #396504] Tue, 07 April 2009 01:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support

Regards
Michel
Re: ORA 600 error [message #396561 is a reply to message #396504] Tue, 07 April 2009 03:58 Go to previous messageGo to next message
cookiemonster
Messages: 13961
Registered: September 2008
Location: Rainy Manchester
Senior Member
I don't see anything in your query that requires an inline view.
Just move the final AND (with the subquery) to the inner select and remove the two outer ones.
Actually that last clause looks like it should be a completely seperate select as it's not linked to the rest of the query in any way.
Re: ORA 600 error [message #396600 is a reply to message #396561] Tue, 07 April 2009 05:41 Go to previous messageGo to next message
raghud
Messages: 7
Registered: April 2009
Junior Member
The same query when executed on 10gr2works perfectly fine. but on 11.1.0.6 throws that error. Can some one point out which part may be causing the error. I know i am asking for too much.
Re: ORA 600 error [message #396605 is a reply to message #396504] Tue, 07 April 2009 05:48 Go to previous message
cookiemonster
Messages: 13961
Registered: September 2008
Location: Rainy Manchester
Senior Member
We're not going to be able to give you a better description of what is causing the error than oracle have, all we can do is make suggestions to avoid it - so reread my previous post.

Thinking about it I'm assuming that mu_id is the primary key - if it is my suggestion should work. If not you're going to have to give us a lot more information on how the tables are joined if you want a suggestion for a re-write.
Failing that you're just going to have to upgrade to 11.1.0.7.

EDIT: added last two paras

[Updated on: Tue, 07 April 2009 05:52]

Report message to a moderator

Previous Topic: Number format with Decimals (merged)
Next Topic: Join and select help
Goto Forum:
  


Current Time: Thu Dec 12 04:19:08 CST 2024