Oracle database error code ORA-02040 – remote database string does not support two-phase commit

Oracle Database Error Code ORA-2040 Description :
remote database string does not support two-phase commit
Error 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.

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


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , , , ,
No Comment Yet   
«
»