Re: Update on VIEW
From: DanHW <danhw_at_aol.com>
Date: 21 Feb 2000 02:17:20 GMT
Message-ID: <20000220211720.16622.00000855_at_ng-bh1.aol.com>
Date: 21 Feb 2000 02:17:20 GMT
Message-ID: <20000220211720.16622.00000855_at_ng-bh1.aol.com>
>Hi,
>
>When I wanted to perform update on a newly created view (whose component
>is also another view and table) I got error message as follows.
>-------------------------
>ORA-01779: cannot modify a column which maps to a non key-preserved table
>-------------------------
>
>I'd be grateful for any information, recommendation of reading, etc. which
>would allow me to execute update.
I don't have the exact reference with me, but if you have access to metalink, do a serach on "key preserved" or "key-preserved". There is an article there that explains it. (I looked it up last week...)
Dan Hekimian-Williams Received on Mon Feb 21 2000 - 03:17:20 CET