| Strange ERROR With UNION [message #28083] |
Thu, 27 November 2003 08:28  |
Rupesh Rajan
Messages: 2
Registered: November 2003
|
Junior Member |
|
|
Hi ,
I am facing a problem with unions
When I run the sql given below i get the following error :
ORA-00600: internal error code, arguments: [[5213]], [[]], [[]], [[]], [[]], [[]], [[]], [[]]
SQL Statement:
SELECT ORDHEAD.CARR_TYPE, ROUTLINE.ROUTE_ID,
PICKLINE.PICKLINE_TYPE,PICKS.TRANSACT_ID
FROM ORDHEAD,PICKS,PICKLINE,ROUTLINE
WHERE ORDHEAD.ORD_CNTRL_NO = PICKS.ORD_CNTRL_NO
AND PICKS.PICK_LINE = PICKLINE.LINE_ID
AND ORDHEAD.CUST_DEA_NO = ROUTLINE.DEST_ID
AND PICKS.FAILED_PICK_FLG ='N' AND PICKS.CMPL_TIME IS NULL
UNION
SELECT ORDHEAD.CARR_TYPE, ROUTLINE.ROUTE_ID,
PICKLINE.PICKLINE_TYPE,PLTMOVSG.TRANSACT_ID
FROM ORDHEAD,PLTMOVSG,PICKLINE,ROUTLINE
WHERE ORDHEAD.ORD_CNTRL_NO = PLTMOVSG.PROC_CNTRL_NO
AND PLTMOVSG.LINE_ID = PICKLINE.LINE_ID
AND ORDHEAD.CUST_DEA_NO = ROUTLINE.DEST_ID
AND PLTMOVSG.FAILED_PICK_FLG ='N'
AND PLTMOVSG.END_TIME IS NULL
AND PLTMOVSG.TASK_TYPE = 'PIK'
Surprisingly, If i run the same sql replacing the 'union' with 'union all' i do not get any error.
But the result is not the desired one.
I had checked the Orafaq but could not crack it. Request help on this error.
thanks in advance,
regards,
Rupesh Rajan
|
|
|
|
| Re: Strange ERROR With UNION [message #28084 is a reply to message #28083] |
Thu, 27 November 2003 09:23  |
Frank Naude
Messages: 4596
Registered: April 1998
|
Senior Member |
|
|
Hi,
What version of Oracle are you running? If you are
using a version below 8.1.6.3 you are probably
hitting bug 1331849,
Description: Queries with a UNION ALL and more than
one disk sort operation may fail with error ORA-600
[[5213]]
Fixed in: 8.1.6.3 or above and 8.1.7.0 and above
Solution: Upgrade or apply the latest patch set
Best regards.
Frank
|
|
|
|
| Re: Strange ERROR With UNION [message #28087 is a reply to message #28084] |
Thu, 27 November 2003 21:00 |
Rupesh Rajan
Messages: 2
Registered: November 2003
|
Junior Member |
|
|
Hi Frank ,
Thanks for the reply.
I am working on Oracle 8.1.6.0.0 and would also need the query running on Oracle version 7.0.
If the patch is available for this bug can you forward me the link from which I can download this patch.
Once again thanks for the prompt reply.
regards,
Rupesh Rajan
|
|
|
|
| Re: Strange ERROR With UNION [message #28088 is a reply to message #28087] |
Thu, 27 November 2003 22:18 |
Frank Naude
Messages: 4596
Registered: April 1998
|
Senior Member |
|
|
Hi Rupesh,
The Oracle 8.1.6.3 patch-set can be downloaded from
Metalink - http://metalink.oracle.com/
You will most likely not get the problem on Oracle7.
Nevertheless, you should test to be sure.
BTW: Both Oracle 7 and 8.1.6 was de-supported some
time ago. Maybe you should think of upgrading to a
more current release of Oracle.
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
