You are here: Home // Oracle 11g // ORA-12840: cannot access a remote table after parallel/insert direct load txn

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. See the solution below.

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

Database version: Oracle 11g Release 2 (11.2)

Tags: ,

Leave a Reply

Copyright © 2009 Oracle Error Codes Database. All rights reserved.
Powered by WordPress.
Promotes: pasy zębate bagażniki rowerowe Skoda Promocje sprzedaż rusztowań Liga Typerów