ORA-02040: remote database string does not support two-phase
commit



ORA-02040: remote database string does not support two-phase commit..

Answer / guest

Cause: the database was potentially updated but does not
support prepare to commit (as determined by its logon
transaction traits). The transaction was rolled back.

Action: Do not attempt to update the remote database unless
it is the only database updated in one transaction.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-00123: idle public server terminating

1 Answers  


ORA-01621: cannot rename member of current log if database is open

1 Answers  


PLS-01423: Subquery on right-hand-side in set clause

1 Answers  


ORA-08176: consistent read failure; rollback data not available

1 Answers  


DRG-51301: error releasing dml Queue lock

1 Answers  


ORA-31630: a job name is required to attach a job for user string

1 Answers  


ORA-12665: NLS string open failed

1 Answers  


ORA-09215: sfqio: error detected in IOCompletionRoutine

1 Answers  


ORA-12689: Server Authentication required, but not supported

1 Answers  


LPX-00660: Not a well-formed document or external entity.

1 Answers  


LSX-00282: duplicate notation name "~S"

1 Answers  


TNS-00114: Internal error- Allocation of addresses not performed

1 Answers  


Categories