Stepwise-Lab

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

Through a join view you can only change a table whose primary key is still unique in the view.

On the exam

This error belongs to the topic Views, sequences, indexes of exam 1Z0-071.

In the SQL lab the same explanation appears next to your own statement, with a hint about what to change in it.

All Oracle errors