Encountering ORA-01779 When Updating Joined Tables

Data and Databases
1

Updating joined tables throws ORA-01779. How can this be fixed?

UPDATE (
  SELECT a.flag FROM delta_table a JOIN sigma_table b ON a.num = b.num
  WHERE a.flag = 'DONE' AND b.group_id IS NULL
) alias SET alias.flag = 'UPDATED';
2

hey, try splittin the update into separate queries so each table updates solo. i’ve seen that help bypass the ora-01779 error. anyone else experimenting with this or other work-arounds?

3

hey, try using merge instead of join update. worked for me and cleared the ora-01779 error. give it a shot, might work for you too.