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

原因描述

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.

在创建table时执行谓词移动操作可能会导致失败造成0RA-600或者ORA-7445

解决办法

1. 在创建table的时候不要用谓词

Oracle谓词有group by 、on、join、order by等

2. 修改Oracle参数

alter session set "_pred_move_around"=FALSE;