Oracle DBA, How To, Error, Cause and Action

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.