sql> create table t as select * from all_objects;

sql> insert /*+ append */ into t select * from t;

这类语句不能连续执行。

ORA-12838: cannot read/modify an object after modifying it in parallel

这类语句不能连续执行，必须等上一个语句commit或者rollback后，才可以继续执行。

metalink的解释为：

Error: ORA 12838

Text: Cannot read/modify an object after a parallel modification on it in

the same transaction

---------------------------------------------------------------------------

Cause: Multi Statement Parallel DML restriction violated

Action: Once a table has been modified in parallel, no more read or

modification statements are allowed on that table, within the same

transaction. Rewrite the transaction, or brake it up into two

transactions.

ITPub博客

/+ append / ORA-12838错误