ORA-01779: cannot modify a column which maps to a non key-preserved table
Can anyone tell me why I am getting this error. I understand that there neds to be a key-preserved table (the rows being updated should only return 1 row) for this update to work. There are unique indexes on the joined column (actvity_id) on both tables, but i'm still gettign this error. Any ideas?
UPDATE (SELECT a.actvty_id,a.filg_entry_dt,a.filg_rcv_dt,d.actvty_id, d.entry_date, d.receipt_date
FROM soritmod.actvty a, dcitmod.doc_control d
WHERE a.actvty_id=d.actvty_id) V
SET v.receipt_date=v.filg_rcv_dt,
v.filg_entry_dt=v.entry_date;