Oracle DB Error ORA-12840 cannot access a remote table after parallel/insert direct load txn

The following is the cause of this error:

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

Action you can take to resolve this issue: Commit/roll back the PDML transaction first, and then perform the distributed access, or perform the distributed access before the first PDML statement in the transaction.

Tags: Database, Microsoft, Oracle, SQL, Software, DBMS, Error Messages, Directory

Related