---
title: "ORA-12838: cannot read/modify an object after modifying it in parallel"
author: "winzenghua"
date: "2009-06-15T16:12:00Z"
tags: []
slug: "ora-12838-cannot-read-modify-an-object-after-modifying-it-in-parallel"
draft: false
lastmod: "2009-06-15T16:12:00Z"
id: 987877
url: "https://java4gis.iteye.com/blog/987877"
---

如果用了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

insert /\*+ append \*/ into table 操作对于这个表的锁级为6，而insert 操作对这个锁级为3 ，在同一session下，执行了上面这个操作，没有提交/回滚事务，然后有对table进行 select....等操作就会报上面的错误

我的过程中 跑了3.55个小时后 很郁闷哦！

if

insert /\*+append\*/ into table a

select * from c;

insert /\*+append\*/ into table a

select * from b

end if