[ORACLE SQL] - Join Update - ORA-01779

Oracle join update'lerde ORA-01779: cannot modify a column which maps to a non key-preserved table hatası alacak olursanız update query'sine BYPASS_UJVC  (Bypass Updateable Join View Constraints) hint'ini eklemeniz yeterli olacaktır.

UPDATE (SELECT /*+ BYPASS_UJVC */
         c.name old_name, ci.name new_name, c.rowid
FROM country_old c, country_new ci
WHERE c.name <> ci.name
AND c.code = ci.code)
SET old_name = new_name;