Re: insert table error

Posted by Roshan on Sep 21, 2018; 3:27am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/insert-table-error-tp6769p6770.html

I checked the docs,

Versions 9.2, 10.1, 10.2, 11.1, 11.2, 12.1

Error:  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.

Should I remove the APPEND?