Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

ORA-12840

cannot access a remote table after parallel/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/rollback the PDML transaction first, and then perform the distributed access, or perform the distributed access before the first PDML statement in the transaction.