Saturday, 21 January 2012

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.

No comments:

Post a Comment