Update base on join view fails with ora 1779

Author: asktom.oracle.com | Published: 11th Apr 2008 | Visited: 190 times | Add Comment
Filed in: Oracle FAQ

Hi, Here is the problem update (select t1.* from T1,T2 where t1.col=T2.col) t set col4='toto' ora-1779 even if i try /*+bypass_ujvc*/ in my update update /*+bypass_ujvc*/ (select t1.* from T1,T2 where t1.col=T2.col) t set col4='toto'...

Read Article

Sponsored Links

• RESTRICT USERS TO INSERT/UPDATE DATA EXCEPT THEIR PRIVILIEGES DEAR TOM i learn a lot from this platform as a new dba i have a situation here. i did't write code/script here because i havn't any idea that how i ask from you? i have tried to convey my.. i have a database of almost 60 tables. application d ...

• LINQ TO SQL All Common Operations (Insert,Update,Delete,Get) in ONE BASE Class Base Class to perform all Common LINQ To SQL Operat ...

• Upload and view images to/from an Oracle database using an XML Web Service This article explains about uploading and fetching images to/from an Oracle database using XML web services and ASP. ...

• Referencing values in update trigger Tom, When a before update for each row trigger fires and a certain column was not set in the update statement, the :new value for the "certain column" appears to be set to the :old value by the time the trigger fires. Is there a way to determine ...

• Article :: 4Ci Update: More Solutions for Command, Control, and Communications in Time of Disaster Every organization should be prepared with alternative methods for accessing communications systems in case of an emergen ...

• Java SE 6 Update 10 Beta This update introduces new Java Plug-In, Java Kernel, Java Deployment Toolkit, new Java system properties, Java Quick Starter, hardware acceleration support, and Nimbus to provide an optimized consumer-end user experie ...

• A base SharePoint web part for AJAX in ASP.NET 3.5 A base SharePoint web part to support AJAX in ASP.NET ...

• Simple example of MVC ( Model View Controller ) design pattern for abstraction Simple example of MVC ( Model View Controller ) design pattern for abstrac ...

• Linq Transactions using a custom base Datacontext How to simplify Linq Transactions using a custom base Datacon ...

• Nesting the DropDownList to Gridview in ASP.NET 2.0 to update Nesting the DropDownList to Gridview in ASP.NET 2.0 to update a co ...

Next: Partitioning tables with unequal partitions.