Oracle Error Message
ORA-02040: remote database string does not support two-phase commit
Reason for the Error
the database was potentially updated but does not support prepare to commit (as determined by its logon transaction traits). The transaction was rolled back.
Solution
Do not attempt to update the remote database unless it is the only database updated in one transaction.