Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

NZE-28791: certificate verification failure

1 Answers  


ORA-14643: Hakan factor mismatch for tables in ALTER TABLE EXCHANGE PARTITION

1 Answers  


TNS-00089: process_name is one of Interchange, CMANAGER, or Navigator

1 Answers  


SQL*Loader-00652: Invalid zoned decimal byte.

1 Answers  


ORA-12531: TNS:cannot allocate memory

1 Answers  






ORA-06776: TLI Driver: error sending parms

1 Answers  


PLS-00380: functions and procedures are not included in this release of PL/SQL

1 Answers  


ORA-03245: Tablespace has to be dictionary managed, online and permanent to be able to migrate

1 Answers  


RMAN-00564: host data too long

1 Answers  


ORA-00346: log member marked as STALE

1 Answers  


PLS-01714: ANSI expects a column name not a literal value here

1 Answers  


ORA-06106: NETTCP: socket creation failure

1 Answers  






Categories