| ORA-07445 [message #412552] |
Fri, 10 July 2009 00:06  |
vinniora
Messages: 56
Registered: October 2008
Location: Mumbai
|
Member |
|
|
WHEN I AM FIRING A QUERY
SELECT NVL(ab.c_nm,c.c_nm) , NVL(ab.cg,c.cg), ab.aqty, ab.bqty,c.cqty, NVL(ab.aqty,0)+ NVL(ab.bqty,0)+ NVL(c.cqty,0) tot, 1 SEQ FROM
(SELECT NVL(a.c_nm,b.c_nm) c_nm, NVL(A.cg,b.cg) cg , SUM(A.QTY) aqty, SUM(B.QTY) bqty, NULL cqty, SUM(A.QTY+B.QTy) sumab
FROM (SELECT SHIFT, Cargo_Name(cargo_type) C_NM, cargo_type cg, qty FROM ISP.ZJ_JETTY_OP_AUTO WHERE WORK_DATE = '08072009'
AND SHIFT = 'A') A
FULL OUTER JOIN
(SELECT SHIFT, Cargo_Name(cargo_type) c_nm, cargo_type cg, qt
FROM ISP.ZJ_JETTY_OP_AUTO
WHERE WORK_DATE = '08072009'
AND SHIFT = 'B') b
ON (a.c_nm = b.c_nm)
GROUP BY NVL(a.c_nm,b.c_nm), NVL(A.cg,b.cg)) AB
FULL OUTER JOIN
SELECT c.c_nm c_nm, c.cg , NULL aqty, NULL bqty, c.QTy cqty, c.QTy sumab
FROM(SELECT SHIFT, Cargo_Name(cargo_type) C_NM, cargo_type cg, qty
FROM ISP.ZJ_JETTY_OP_AUTO
-- where cargo_type= 10000079
WHERE WORK_DATE = '08072009'
AND SHIFT = 'C') c) c
ON (ab.c_nm = c.c_nm)
i am getting a error
Reason code: 005a
*** 2009-07-10 10:13:51.510
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [vopdup()+529] [SIGBUS] [Invalid address alignment] [0x00000002A] [] []
Why is this happening, not only this i am not able to use explain plan for that it returns a error end of communication file.plz help me out
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
