Bug 14275161 - ORA-600 [rwoirw: check ret val] on CTAS with predicate move around

最新推荐文章于 2025-05-27 08:43:16 发布

转载最新推荐文章于 2025-05-27 08:43:16 发布 · 2.2k 阅读

文章标签：

#rwoirw #check ret val

Oracle DB 专栏收录该内容

772 篇文章

订阅专栏

本文介绍了一个关于 Oracle Server 在使用 CTAS (Create Table As Select) 操作时可能出现的 ORA-600[rwoirw:checkretval] 错误及解决办法。该问题主要影响 11.2.0.4 和 11.2.0.3 版本，并在进行谓词移动操作时发生。文中提供了禁用谓词移动的临时解决方案。

Bug 14275161 - ORA-600 [rwoirw: check ret val] on CTAS with predicate move around (Doc ID 14275161.8)

This note gives a brief overview of bug 14275161.

The content was last updated on: 17-DEC-2015
Click here for details of each of the sections below.

Affects:

Product (Component) Oracle Server (Rdbms)
Range of versions believed to be affected (Not specified)
Versions confirmed as being affected
11.2.0.4
11.2.0.3

Platforms affected Generic (all / most platforms affected)

Fixed:

The fix for 14275161 is first included in
12.1.0.1 (Base Release)
11.2.0.4 Bundle Patch 16 for Exadata Database (Apr 2015)
11.2.0.4 Patch 11 on Windows Platforms

Interim patches may be available for earlier versions - click here to check.

Symptoms:	Related To:
Process May Dump (ORA-7445) / Abend / Abort Internal Error May Occur (ORA-600) ORA-600 [rwoirw: check ret val] Dump in or under qervwRestoreViewBufPtrs / evaopn3	Optimizer _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] or an ORA-7445.
 
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

Bug:14275161 (This link will only work for PUBLISHED bugs)
Note:245840.1 Information on the sections in this article