Re: Oracle 9.2.0.1.0 For Windows performance question

Aguyngueran wrote:

> >
> > Of course if that doesn't work the OP might try
> >
> > CREATE TABLE x AS
> > SELECT * FROM y;
> >
> > TRUNCATE TABLE y;
> >
> > INSERT INTO y
> > SELECT * FROM x;
> >
> > DROP TABLE x;
> >
> > But sthg is far more efficient. Why I used it last night several times
> > after drinking a bit of single malt. And I've had no complaints so far.
> >
> Oh, come on and give me a break. Please tell me is it possible to do this
> without truncating table. I just want to know how to do this.
> Thanks

Perhaps you should use on the links under my signature.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
http://www.outreach.washington.edu/extinfo/certprog/aoa/aoa_main.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)