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@xxxxxxxxxxxxxxxxxxxx <mailto:william@xxxxxxxxxxxxxxxxxxxx>> 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.)