ORA 600 error [message #396504] |
Tue, 07 April 2009 00:51 |
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 #396561 is a reply to message #396504] |
Tue, 07 April 2009 03:58 |
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 |
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 |
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
|
|
|