Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to Swap Two Tables?
rekaben_at_yahoo.com (RK) wrote in message news:<239f1935.0310310443.3073523c_at_posting.google.com>...
> joel-garry_at_home.com (Joel Garry) wrote in message news:<91884734.0310301433.19cc7704_at_posting.google.com>...
> > rekaben_at_yahoo.com (RK) wrote in message news:<239f1935.0310300915.26b01e94_at_posting.google.com>...
> > > Turkbear <john.g_at_dot.spamfree.com> wrote in message news:<kn00qv4nf0rv3trj2n8q9319ul3v6aapuc_at_4ax.com>...
> > > > rekaben_at_yahoo.com (RK) wrote:
> > > >
> > > > ...
> >
> >
> > What's the problem with MINUS?
> >
> > jg
>
> Some tables are just too big, and it never finishes if I do that.
>
> RK
Have you/your DBA gone through proper tuning procedures? If so, you may indeed be better off using OS tools. If not, you need to adjust your administration procedures. I haven't seen anything in this thread that leads me to believe minus shouldn't work reasonably well, especially if you are able to dump the entire two tables to the OS in a short period. Perhaps you should post an explain plan and let us know exactly what "too big" means.
Just remember, anything you do outside of Oracle will have a disproportionate maintenance cost, so it better be justified. I do things like this all the time, because I take on problems others have given up on, but I actively discourage it as SOP.
jg
-- @home.com is bogus. http://www.digimorph.org/Received on Fri Oct 31 2003 - 16:13:06 CST
![]() |
![]() |