ORA-12838: cannot read/modify an object after modifying it in parallel
来源:互联网 发布:java xp 32位 编辑:程序博客网 时间:2024/05/06 05:38
如果用了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
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
- ORA-12838: cannot read/modify an object after modifying it in parallel
- ORA-12838: cannot read/modify an object after modifying it in parallel
- ORA-12838: cannot read/modify an object after modifying it in parallel
- ORA-12838: cannot read/modify an object after modifying it in parallel
- ADODB使用excel的"Cannot modify the design of table 'xxxx'. It is in a read-only database"的问题
- ORA-12840: cannot access a remote table after parallel/insert direct load txn
- ORA-01187: cannot read from file because it failed verification tests ORA-01110: data file 201: '/
- The Nook cannot read this file. it may be an unsupported format
- 关于ORA-01187: cannot read from file because it failed verification tests 的处理方法
- delphi 错误 Cannot modify a read-only dataset
- TQuery的cannot modify a read-only dataset解决方法
- ORA-01776: cannot modify 和instead of 触发器
- ORA-20001: FND-ORG_ID PROFILE CANNOT READ
- ORA-20782: Cannot DROP object used in Oracle GoldenGate replication while trigger is enabled
- Increment V.S. Read-Modify-Write in HBase
- [hbase]Increment V.S. Read-Modify-Write in HBase
- The final local variable xxx cannot be assigned, since it is defined in an enclosing type
- The final local variable xxx cannot be assigned, since it is defined in an enclosing type
- 乘法和除法的汇编形式
- 程序员的十层楼(8~9层)作者: 周伟明
- Sql Server 2000 行转列的实现(横排)
- tar 详解
- BOM浏览器对象模型
- ORA-12838: cannot read/modify an object after modifying it in parallel
- 程序员的十层楼( 第10层 大哲)作者: 周伟明
- 编写Linux下的UDP Client/Server程序
- 女孩看了自省,男孩看了激励
- makefile 自动变量
- 网页特效代码
- Internet信息中的默认网站启不来的解决方案
- Jboss seam
- 一个linux UDP网络通讯的例子源代码(server、client方式)