Skip to Main Content

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

user8731258Jun 26 2012 — edited Jun 26 2012
I am trying to execute the following dml but i am gettig the abve mentioned error

Is it possible to recitfy this error without creating a primary key on the column c1 of TABLE a
UPDATE   (
SELECT   a.c1
            FROM    a,  b
           WHERE       a.c1 IS NULL
                   AND a.c2 = b.c2
                   AND a.c3 = b.c3
                   ) c
   SET   c.c1 = 'drop';
This post has been answered by €$ħ₪ on Jun 26 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 24 2012
Added on Jun 26 2012
3 comments
511 views