Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Update rows in a table get ora-error 01779
Can you please post the complete table definition including all indexes and
constraints?
Martin
jc wrote:
>
> Hi,
>
> I'm trying to update a table. The following sql still doesn''t work I get the error:
> ORA-01779: cannot modify a column which maps to a non key-preserved
> table".
>
> However both are base tables and have their primary keys.
>
> Much appreciate any help!
>
> update (
> select tab1.x tobeupdated,
> tab2.y tobequal
> from tab1, tab2
> where tab1.field1x = tab2.field2x
> and tab1.field1y = tab2.field2y
> )
> set tobeupdated = tobequal
>
> Thanks,
>
> JC
Received on Mon Jul 22 2002 - 04:24:02 CDT