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-30340: illegal dimension name

1 Answers  


ORA-01352: tablespace given for Logminer spill does not exist

1 Answers  


ORA-13141: invalid RANGE window definition

1 Answers  


ORA-16722: unable to set LOG_ARCHIVE_DEST_STATE_n parameters

1 Answers  


ORA-29324: SET COMPATIBILITY release string format is wrong

1 Answers  






ORA-16706: no resource guard is available

1 Answers  


PLS-00424: RPC defaults cannot include Package State

1 Answers  


ORA-07700: sksarch: interrupt received

1 Answers  


ORA-13832: category name specified is invalid

1 Answers  


QSM-01037: Query Rewrite failed to allocate the necessary query join graph

1 Answers  


TNS-00071: where <command> is one of following:

1 Answers  


TNS-12153: TNS:not connected

1 Answers  


Categories