Oracle执⾏CreateTableAs报ORA-600错误
oracle decimal类型1. 执⾏语句
CREATE TABLE TempVIDSFrom5f009f41e4a843e09 as
Select distinct ZJJSPZ_PZNM as NM,ZJJGDWGX_DWBH as GS,ZJJSPZ_PZBH as BH,ZJJSPZ_PZRQ as PZRQ,ZJJSPZ_PZBH as PZBH,ZJJSPZ_PZLX as PZLX, (SELECT cast(SUM(FL.ZJPZFL_JE) as decimal(20,2)) FROM from ZJPZFL
INNER JOIN ZJJSPZ ON ZJJSPZ_PZNM = ZJPZFL_PZNM
INNER JOIN ZJZH FLZH ON ZJPZFL_ZHBH=FLZH.ZJZH_ZHNM
INNER JOIN LSBZDW ON FLZH.ZJZH_DWBH=LSBZDW_DWBH
INNER JOIN LSWBZD ON FLZH.ZJZH_BZBH=LSWBZD_BZBH
INNER JOIN ZJJGDWGX ON ZJJGDWGX_JGBH=ZJJSPZ_JGBH AND (ZJJGDWGX_BZDM=ZJPZFL_BZ OR ZJJGDWGX_BZDM='-1')
LEFT JOIN CodeItems ON ZJPZFL_ZY=NAME AND SetID='Z001'
LEFT JOIN ZJZH ZXZH ON FLZH.ZJZH_ZHNM=ZXZH.ZJZH_ZHNM AND ZJJGDWGX_DWBH=ZXZH.ZJZH_DWBH AND ZXZH.ZJZH_NWBZ='1'
LEFT JOIN ZJJSDJ ON ZJJSDJ_DJNM=ZJJSPZ_DJNM AND ZJJSPZ_GLB='ZJJSDJ'
LEFT JOIN HPBSSQ ON HPBSSQ_DJNM=ZJJSPZ_DJNM AND ZJJSPZ_GLB='HPBSSQ'
Where1=1and ZJJSPZ_JZBZ='1'and ZJJGDWGX_DWBH ='01020100'
2. 错误信息
ORA-00600: 内部错误代码，参数:[rwoirw: check ret val], [],[],[],[],[],[],
3. 原因分析
查看trace⽂件没有任何有帮助的信息，只执⾏后⾯的select语句正常，create table报错。
⽽且，Oracle11.2.0.4存在此问题，11.2.0.1不存在此问题。应该是11.2.0.4的bug。
4. 解决⽅法
更新OracleBug
附：
Bug 14275161 - ORA-600 [rwoirw: check ret val] on CTAS with predicate move around (Doc ID 14275161.8)
Modified:Feb 12, 2014Type:PATCH
Bug 14275161  ORA-600 [rwoirw: check ret val] on CTAS with predicate move around
This note gives a brief overview of bug 14275161.
The content was last updated on: 11-FEB-2014
Click  for details of each of the sections below.
Affects:
Fixed:
Interim patches may be available for earlier versions - click  to check.
Symptoms:Related To:
_pred_move_around
CREATE TABLE .. AS SELECT
Description
A CTAS (Create table as select) operation undergoing predicate move around
may fail during execution with an ORA-600 [rwoirw: check ret val] Workaround Disable predicate move around before executing the CTAS.
eg:
alter session set "_pred_move_around"=FALSE;
Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that
you are encountering this problem. For questions about this bug please consult Oracle Support.
References
(This link will only work for PUBLISHED bugs)
Information on the sections in this article
--采⽤metalink的⽅案，问题解决
alter session set "_pred_move_around"=true;

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。