GeekArticles
FAQ
Oracle FAQ
FAQ
Oracle FAQUpdate base on join view fails with ora 1779
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'...
Sponsored Links
Read Next: date field in many to many relationships
Related Topics
Subscribe via RSS
Oracle FAQ
- Synchronize data from remote location
- Oracle Fundamentals
- How to connect SQLPlus without tnsnames.ora
- Best Practices for App Server Keep Alive
- bind variables in triggers
- how to avoid outer joins
- One 900 column table versus ten 90 column tables.
- Does select generate undo ?
- Performance Question
- Help analyze statspack report
