Oracle Error: ORA-02064 - Distributed operation not supported

Oracle Error: ORA-02064

Error Description:
Distributed operation not supported

Error Cause:
One of the following unsupported operations was attempted:

1. array execute of a remote update with a subquery that references a dblink.

OR

2. an update of a long column with bind variable and an update of a second column with a subquery that both references a dblink and a bind variable.

OR

3. a commit is issued in a coordinated session from an RPC procedure call with OUT parameters or function call.

Action:
1.) Simplify remote update statement.

2.) If your using merge command for merging data from one server to another on dblink then just split the merge command into two set one for insert and one for update and then try.