本文介绍了一个在Oracle数据库中创建表并插入数据时遇到的ORA-12838错误，并提供了解决方案：使用rdbms,admin下的utlxplan脚本来解决该问题。
SQL> create table t as select * from all_objects;
Table created.
SQL> insert /*+ append */ into t select * from t;
49183 rows created.
Execution Plan
----------------------------------------------------------
ERROR:
ORA-12838: cannot read/modify an object after modifying it in parallel
Table created.
SQL> insert /*+ append */ into t select * from t;
49183 rows created.
Execution Plan
----------------------------------------------------------
ERROR:
ORA-12838: cannot read/modify an object after modifying it in parallel
SP2-0612: Error generating AUTOTRACE EXPLAIN report
通过查资料，显示运行rdbms,admin下的utlxplan脚本即可！
扫一扫
965
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
