SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01779 cannot modify a column which maps to a non key-preserved table

MagnetoApr 12 2017 — edited Apr 12 2017

I have two tables without any keys. And we have an update statement as follows

Update ( select t1.status,'success' new_status from table1 t1, table2 t2 where t1.column1 =t1.column1)

Set status=new_status;

This statement throws ora 01799, though the join returns always distinct records and there are no duplicates in both the tables.

It used to work in 11.1 but when we upgraded to 11.2 it started throwing the error.

Appreciate your help

Magneto

Locked Post

New comments cannot be posted to this locked post.

Locked on May 10 2017

Added on Apr 12 2017

9 comments

9,208 views