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-36392: (XSMXCLEA02) When using CLEAR with the PRECOMPUTES or NONPRECOMPUTES options, you must supply an AGGMAP.

1 Answers  


NNO-00628: setting maximum reforwards per query to number

1 Answers  


IMG-00830: boundary queue is full

1 Answers  


ORA-27010: skgfwrt: write to file failed

1 Answers  


ORA-27081: unable to close the file

1 Answers  


ORA-30742: cannot grant SELECT privilege WITH HIERARCHY OPTION on this object

1 Answers  


EXP-00104: datatype (string) of column string in table string.string is not supported, table will not be exported

1 Answers  


IMP-00009: abnormal end of export file

1 Answers  


ORA-06905: CMX: connect error

1 Answers  


ORA-31610: cannot call this function from a non-master process

1 Answers  


SQL*Loader-00932: Could not truncate table string.

1 Answers  


ORA-26714: User error encountered while applying

3 Answers  


Categories