Oracle DB Error ORA-02060 select for update specified a join of distributed tables

The following is the cause of this error:

An attempt was made to join tables in different remote databases in a SELECT... FOR UPDATE statement.

Action you can take to resolve this issue: Joined tables in a SELECT statement with the FOR UPDATE clause must reside at the same database. Simplify the SELECT... FOR UPDATE statement so that it joins only tables in the same database.

Tags: Database, Microsoft, SQL, Oracle, Software, DBMS

Related