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-06763: TLI Driver: error sending disconnect

1 Answers  


PCC-02207: Invalid macro name

1 Answers  


TNS-12631: Username retrieval failed

1 Answers  


NNL-00573: load_tnsnames [<file>, ... ] : load tnsnames into ONames

1 Answers  


ORA-07579: spini: $DCLEXH failure

1 Answers  






TNS-12633: No shared authentication services

1 Answers  


LSX-00027: property "~s" unknown

1 Answers  


ORA-22130: buffer size [string] is less than the required size [string]

1 Answers  


ORA-01246: recovering files through TSPITR of tablespace string

1 Answers  


ORA-14292: Partitioning type of table must match subpartitioning type of composite partition

1 Answers  


NZE-29045: Renegotiation request has been refused.

1 Answers  


SQL*Loader-00919: Error during upi fetch: [number]

1 Answers  


Categories