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/