最近在帮助网友处理一个关于ora-00600内部报错问题。
创建语句为create table t1 sa select * from t2;
在执行cretae table tablename1 as select * from tabelname2时,报错如下:
ORA-00600: 内部错误代码, 参数: [KGHALP1], [0X000000000], [], [], [], [], [], []
查询相关metalink文档如下:
![](https://i-blog.csdnimg.cn/blog_migrate/200491d1ae6203cbdf7e02dca39a75b1.gif)
Bug 10378052 ORA-600[KGHALP1] during insert of XMLTypeThis note gives a brief overview of bug 10378052.The content was last updated on: 29-JUN-2016 Click here for details of each of the sections below. Affects:
Fixed:
DescriptionORA-600[KGHALP1] can occur when inserting an XMLType Rediscovery Notes ORA-600[KGHALP1] with xmltype The trace is likely to show the error is on heap name="qmxlu subheap" Workaround The ORA-600 occurs as the memory size request is too large. This fix changes the internal error to a graceful user error . Hence a workaround is to address the reason for needing a very large memory allocation if the cause can be identified.
|
解决方案如下:
![](https://i-blog.csdnimg.cn/blog_migrate/200491d1ae6203cbdf7e02dca39a75b1.gif)
Bug 10378052 ORA-600[KGHALP1] during insert of XMLTypeThis note gives a brief overview of bug 10378052.The content was last updated on: 29-JUN-2016 Click here for details of each of the sections below. Affects:
Fixed:
DescriptionORA-600[KGHALP1] can occur when inserting an XMLType Rediscovery Notes ORA-600[KGHALP1] with xmltype The trace is likely to show the error is on heap name="qmxlu subheap" Workaround The ORA-600 occurs as the memory size request is too large. This fix changes the internal error to a graceful user error . Hence a workaround is to address the reason for needing a very large memory allocation if the cause can be identified.
|