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-36874: (XSFTDSC04) Expression string cannot be used to define a column in a LIMITMAP.

1 Answers  


ORA-31201: DBMS_LDAP: generic error: string

1 Answers  


ORA-06577: output parameter not a bind variable

1 Answers  


ORA-26019: Column string in table string of type string not supported by direct path

1 Answers  


ORA-25200: invalid value string, QUEUE_NAME should be [SCHEMA.]NAME

1 Answers  






SQL*Loader-00703: Internal error: argument number

1 Answers  


ORA-19763: compatibility version string is higher than maximum allowed: string

1 Answers  


ORA-06448: ssvpstp: Failed with unexpected error number.

1 Answers  


ORA-18002: the specified outline does not exist

1 Answers  


DRG-11445: rowid value is invalid: string

1 Answers  


RMAN-08121: keep attributes for the backup are deleted

1 Answers  


ORA-10567: Redo is inconsistent with data block (file# string, block# string)

1 Answers  


Categories