Re: Tuning Update query

OMG! That was about time. I still remember spending hours to get it to work as young consultant.

Am 03.05.2021 um 16:39 schrieb Jonathan Lewis:
> 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
> <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 <mailto: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