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

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


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.