Re: tables to new dbspace

any better suggestions? Neil Truby wrote: > <tomcaml@yahoo.com> wrote in message > news:1106880366.164635.247230@f14g2000cwb.googlegroups.com... > > not that many tables at all - dozen, tops....had a suggestion to do the > > rename table and insert over into a new one but.... > > i have not used hpl yet, so may be time to dig deeper into that as well > > That's an awful suggestion if they are large, as it will be very slow and > you'll end up with deeply fragmented indexes. At least if you do that drop > the indexes first on the target table then add them once all the data's > loaded ...