Re: Why there is RENAME TABLE but no COPY TABLE?

From: duffybj1@my-deja.com > >Is a script like this good enough to transfer, say 3GB of data (9 >columns of ints and some chars) in a "reasonable" amount of time, or is >there a more efficient way to do this? (And if so, how much more >efficient?) I'd skip the BEGIN WORK and COMMIT WORK, and then I doubt anything would be much quicker, especially if both tables were fragmented by round robin. Everything happens within one instance of the database. *Maybe* HPL raw format unload / load might be quicker, but scarier. :0) ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com