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

SQL*Loader-00957: Error shipping text string across 2-task

1 Answers  


ORA-32587: Cannot drop nonexistent string supplemental logging

1 Answers  


ORA-14097: column type or size mismatch in ALTER TABLE EXCHANGE PARTITION

1 Answers  


ORA-14620: DEFAULT subpartition already exists

1 Answers  


PCC-02370: An EXEC TOOLS MESSAGE host variable is not type char

1 Answers  






ORA-32803: value for string cannot be altered

1 Answers  


ORA-00319: log string of thread string has incorrect log reset status

1 Answers  


NZE-28828: invalid identity type passed

1 Answers  


ORA-13355: SDO_ORDINATE_ARRAY not grouped by number of dimensions specified

1 Answers  


ORA-06793: TLI Driver: server cannot create new process

1 Answers  


ORA-07238: slemcl: close error.

1 Answers  


ORA-09803: Allocation of string buffer failed.

1 Answers  


Categories