ANBOB™

sys@ORCL> conn anbob
Enter password: 
Connected.
anbob@ORCL> create table testap(id number);
 
Table created.
 
anbob@ORCL> insert /*+ append*/ into testap select 1 from dual;
 
1 row created.
 
anbob@ORCL> select * from testap;
select * from testap
              *
ERROR at line 1:
ORA-12838: cannot read/modify an object after modifying it in parallel
 
 
anbob@ORCL> !oerr ora 12838
12838, 00000, "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.
 
anbob@ORCL> insert /*+ append*/ into testap values(2);
insert /*+ append*/ into testap values(2)
                         *
ERROR at line 1:
ORA-12838: cannot read/modify an object after modifying it in parallel
 
 
anbob@ORCL> rollback;
 
Rollback complete.
 
anbob@ORCL> insert /*+ append*/ into testap values(2);
 
1 row created.
 
anbob@ORCL> select * from testap;
 
        ID
----------
         2

note :

insert /*+ append*/ 是直接路径加载几乎不生成redo、undo且并行插入,再进行其它操作也就无法保证事务的原子性，因此必须在append 操作后执行commit，结束事务开始新事务，而此时其它session 是不会报错的.

打赏

微信扫一扫，打赏作者吧～