append插入不能多次未提交插入資料

wisdomone1發表於2012-11-08
APP
SQL> insert /*+ append */ into t_table_1 select level from dual connect by level<=1000000;
 
1000000 rows inserted
 
SQL> insert /*+ append */ into t_table_1 select level from dual connect by level<=1000000;
 
insert /*+ append */ into t_table_1 select level from dual connect by level<=1000000
 
ORA-12838: 無法在並行模式下修改之後讀/修改物件

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/9240380/viewspace-748679/，如需轉載，請註明出處，否則將追究法律責任。

相關文章