---- Napasindayao Don S <oracledba-ezmlmshield-x46944979.[Email address protected] wrote:
Error: ORA 2055
Text: distributed update operation failed; rollback required
-------------------------------------------------------------------------------
Cause: A failure during a distributed update operation may not have rolled
back all effects of the operation.
Since some sites may be inconsistent with others, the transaction must
roll back to a savepoint or roll back entirely.
Action: Roll back to a savepoint or roll back the entire transaction and
resubmit the rolled-back statements.

The other choice is to manually complete the transaction.

The assumption here is that you have a transaction touching multiple databases and Oracle is not the broker of transaction completion. You could be updating something through a database link to another Oracle database or some non-Oracle (gasp!) data source.

> Oracle Experts:
>
> Is anybody familiar with the following ora-err and what causes are:
> ORA-02055: distributed update operation failed; rollback ?
>
> Thanks in advance....
>
> Don
>
>

Oracle LazyDBA home page