ORA-600 (KGHALO2)

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





      

Other related posts: