首页 > 其他 > 详细

ORA-12838

时间:2015-01-30 16:55:16      阅读:427      评论:0      收藏:0      [点我收藏+]
在FORM中连续执行了几个 insert /*+ append */ into ,没提交。运行后报12838错误,经查原因如下:
 
如果用了insert /*+ append */ into table as select .. from table 这样的操作来insert,必须在操作后commit,或是rollback,不然就不能再insert /*+ append */ into table as select .. from table 。
ORACLE报出错误如下:
ORA-12838: cannot read/modify an object after modifying it in parallel
 
解释如下:
ORA-12838 cannot read/modify an object after modifying it in parallel
Cause: Within the same transaction, an attempt was made to add read or modification statements on a table after it had been modified in parallel or with direct load. This is not permitted.
Action: Rewrite the transaction, or break it up into two transactions: one containing the initial modification and the second containing the parallel modification operation

ORA-12838

原文:http://www.cnblogs.com/gary-bao/p/4262326.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!