Re: Oracle 9.2.0.1.0 For Windows performance question

"Aguyngueran" <grzybek_at_mikrus.pw.edu.pl> wrote in message news:cdac6650.0308232335.43ff7bec_at_posting.google.com...
> >
> > 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

It is NOT possible to do it without truncating table. PERIOD.

-- 
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address