ORA-600 (KGHALO2)
Date: Mon, 18 May 2009 14:56:06 -0700 (PDT)
Message-ID: <576650.49106.qm_at_web52007.mail.re2.yahoo.com>
Hi,
in database version 8.1.7.0 and 11.0.3 apps (pretty old one after 6 months we are moving all the data to new 12g apps and db 10gR2 database...now upgrade is not solution...)
When i am executing Materlized view...i get below error
CREATE MATERIALIZED VIEW APPS.PPG_RG_BOD_LBL_MVW
TABLESPACE PPGREGD
BUILD IMMEDIATE
REFRESH COMPLETE ON DEMAND
AS
SELECT
A.MFG_ITEM_NO ITEM_CODE,
D.ITEM_DESC ITEM_DESCRIPTION,
DECODE(F.ADR_HAZD_CLASS,'None','0','1') DG_ADR,
DECODE(F.ADR_HAZD_CLASS,'None','0','1') DG_IATA,
DECODE(F.ADR_HAZD_CLASS,'None','0','1') DG_IMDG,
F.ADR_HAZD_CLASS DG_CLASS,
F.ADR_PACK_GRP PACKAGE_GROUP,
F.ADR_ONU_MAT_CODE UN_NR,
F.SUBSIDIARY_CLASSES SUBSIDIARY_CLASSES
FROM
PPGREG.PPG_CS_BULK_HDR A,
PPGREG.PPG_RG_MSDS_LINK B,
PPGREG.PPG_RG_RESULTS_HDR C,
PPGREG.PPG_RG_REQUEST_HDR D,
PPGREG.PPG_RG_CALC_PARAM E,
APPS.PPG_RG_LABEL_VW F
WHERE
A.BULK_NO = B.ITEM_NO
AND B.OBSOLESCENCE_DATE IS NULL
AND B.RESULT_REQUEST_ID = C.RESULT_REQUEST_ID
AND C.REG_REQUEST_ID = D.REG_REQUEST_ID
AND D.REG_REQUEST_ID = E.REG_REQUEST_ID
AND E.TDG_LOC_CODE = '3820'
AND B.RESULT_REQUEST_ID = F.RESULT_REQUEST_ID;
/
/
PPGREG.PPG_CS_BULK_HDR A,
*
ERROR at line 20:
ORA-00600: internal error code, arguments: [KGHALO2], [0], [], [], [], [], [],
[]
SQL> AND B.RESULT_REQUEST_ID = F.RESULT_REQUEST_ID
*
ERROR at line 33:
ORA-02050: transaction 6.81.951996 rolled back, some remote DBs may be in-doubt ORA-03106: fatal two-task communication protocol error ORA-02063: preceding line from TDG
can we fix above issue as 8i is already not supported by oracle..
Thanks,
Edwin.K
-- http://www.freelists.org/webpage/oracle-lReceived on Mon May 18 2009 - 16:56:06 CDT