Re: Tuning Update query

From the 21c Database Admin Guide:
https://docs.oracle.com/en/database/oracle/oracle-database/21/admin/managing-views-sequences-and-synonyms.html#GUID-077BFD57-3F38-4487-8A92-93ACBB48E2EA

*Starting with Oracle Database Release 21c, it is not mandatory for all updatable columns in a join view to map to columns of a key-preserved table. When updating a join view, ensure that the UPDATE operation is deterministic. *

So the compile-time restriction has been removed and updates of join views are now consistent with the run-time behaviour of the MERGE command. i.e. it work until it breaks with the run-time error: ORA-30926: unable to get a stable set of rows in the source tables

Regards
Jonathan Lewis

On Mon, 3 May 2021 at 15:11, William Robertson <william_at_williamrobertson.net> wrote:

> The ORA-01779 error means you would need a unique index or constraint on
> product_tab (part_dt, tid) to be able to use this syntax. (Strangely, I did
> not get the error in 21c. Maybe there is a new feature I am missing.)
>
>
>

--
http://www.freelists.org/webpage/oracle-l