I wanted to update a table column based on another table data but it faild with
ORA-01779: cannot modify a column which maps to a non key-preserved table.
Update (
select c.central_client_id,cc.id
from client c,central_client cc
where c.id = cc.orginal_client_id)
Set central_client_id = id;
Adding an unique constraint will solve the problem.
alter table central_client add constraint central_client_org_cid_uk unique (orginal_client_id);
