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

ORA-31650: timeout waiting for master process response

1 Answers  


NID-00129: Invalid DBID for datafile "string", expecting number, found number

1 Answers  


ORA-24905: invalid recepient protocol attribute passed into OCI call

1 Answers  


ORA-25532: MTTR specified is too large: string

1 Answers  


ORA-01858: a non-numeric character was found where a numeric was expected

1 Answers  






NCR-03018: NCRO: Failed to make RSLV connection

1 Answers  


ORA-01075: you are currently logged on

1 Answers  


ORA-14156: invalid number of subpartitions specified in [SUBPARTITIONS | SUBPARTITION TEMPLATE] clause

1 Answers  


PCC-02309: illegal formal parameter declaration

1 Answers  


ORA-37117: olapi history retention has been disabled

1 Answers  


ORA-25963: join index must be created on tables

1 Answers  


ORA-24158: invalid table alias

1 Answers  


Categories