Junr DBA wrote:
Refresh MatView causing ORA ORA-00600: internal error code, arguments: [17182], [0x1106559F0], [], [], error.

Database Version: 11.1.0.6, IBM AIX system

when run: dbms_mview.refresh('mart.mv_cust_header','?') , it fails with the above error.

Fixed few times by dropping and rebuldibng the MatView but it is not resolved. The issue is with production system.

Any help on this will be greatly appreciated.

Thanks,
Junr DBA

ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support

If you have access to Metalink.MyOracleSupport then check out doc ID 34779.1 ( ORA-600 [17182] "Heap chunk header BAD MAGIC")
or google around a bit.

Thanks All,

I was also getting the same error while running below query

CREATE TABLE TEMP_TABLE AS select * from (select DATE,CIRCLE from SOMETABLE) PIVOT (MAX(CIRCLE) FOR CIRCLE IN ('xxx' AS "xxx" ,'YYY' AS "YYY" )) order by DATE desc
ORA-00600: internal error code, arguments: [qkngbAllocate.6], [], [], [], [], [], [], [], [], [], [], []

But in Enterprise edition this was running with warning and in Standard one edition it was giving error.

Late i try to set the NLS_SORT at session level and now its running proper in Standard Edition.

ALTER SESSION SET NLS_SORT=BINARY

Its works ......


Regards,