In this post, you’ll learn more about the Oracle ErrorORA-02040: remote database string does not support two-phase commit with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-02040: remote database string does not support two-phase commit
Reason for the Error ORA-02040: remote database string does not support two-phase commit
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 fix the Error ORA-02040: remote database string does not support two-phase commit ?
You can fix this error in Oracle by following the below steps
Do not attempt to update the remote database unless it is the only database updated in one transaction.