tables to new dbspace
hello! i am needing to move some existing tables that are rather large to a different dbspace. what is the best and quickest method to do this? (hoping that the quickest is also the best) infx 9.40 on HP-UX thanks! tom
How many tables? The Chav's suggestion of ALTER FRAGMENT ... INIT IN is good. Set PSORT_NPROCS and if you believe Art maybe PSORT_DBTEMP too to speed up its index build element. It doesn't give you much direct info about what it's up to though, and with a small number of tables I might use HPL. -- Neil Truby t:01932 724027 Director m:07798 811708 Ardenta Limited e:neil.truby@ardenta.com <tomcaml@yahoo.com> wrote in message news:1106853004.824321.235930@z14g2000cwz.googlegroups.com... > hello! > > i am needing to move some existing tables that are rather large to a > different dbspace. > what is the best and quickest method to do this? (hoping that the > quickest is also the best) > infx 9.40 on HP-UX > > > > thanks! > > > tom >
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 thanks for the tips - i will check them out. tom Neil Truby wrote: > How many tables? > The Chav's suggestion of ALTER FRAGMENT ... INIT IN is good. Set > PSORT_NPROCS and if you believe Art maybe PSORT_DBTEMP too to speed up its > index build element. It doesn't give you much direct info about what it's > up to though, and with a small number of tables I might use HPL. > > -- > Neil Truby t:01932 724027 > Director m:07798 811708 > Ardenta Limited e:neil.truby@ardenta.com > > > <tomcaml@yahoo.com> wrote in message > news:1106853004.824321.235930@z14g2000cwz.googlegroups.com... > > hello! > > > > i am needing to move some existing tables that are rather large to a > > different dbspace. > > what is the best and quickest method to do this? (hoping that the > > quickest is also the best) > > infx 9.40 on HP-UX > > > > > > > > thanks! > > > > > > tom > >
<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 ...