Saturday 3 March 2012

ORA-12840: cannot access a remote table after parallel or insert direct load txn

ORA-12840: cannot access a remote table after parallel or insert direct load txn

Cause: Within a transaction, an attempt was made to perform distributed access after a PDML or insert direct statement had been issued.

Action: Commit or rollback the PDML transaction first, and then perform the distributed access, or perform the distributed access before the first PDML statement in the transaction.

No comments:

Post a Comment