Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help with SQL constraint
dean wrote:
>
> The trace files are no longer available, and as I said I had them
> looked at already. But what I would find advantageous is a better
> technique for updating such joins as discussed, as there are several
> tables of similar construct that prevent an updatable join.
If you have the tables and the DDL we should be looking at to help you. And if you have the DML you've be running. What stops you from rerunning it with explain plan?
You are absolutely tenacious with respect to updating a join "as discussed" but is one of many possible solutions. You have yet to state an actual business problem.
By way of explanation this is how you might present a business problem.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Sat Feb 17 2007 - 11:48:57 CST
![]() |
![]() |