Re: moving tables

If the table is small this could not be worth haggling over... But wouldn't copying also be expensive since the new table will be logged? How much more or less would the alter fragment be? Since Alter Fragment handles the locking, create table, coping the data, removing the old table, and unlocking... It is also very easy to script... Eric B. Rowell On 6/8/07, Jack Parker <jack.parker4@verizon.net> wrote: > Alter fragment can be an expensive operation - especially on your logical> logs. I would copy it to the new dbspace - under another name, and then > drop the old one, rename the new one. > > j. > > -----Original Message----- > From: informix-list-bounces@iiug.org > [mailto:informix-list-bounces@iiug.org]On Behalf Of fiedlert@gmail.com > Sent: Friday, June 08, 2007 1:42 PM > To: informix-list@iiug.org > Subject: moving tables > > > is it possible to move certain tables from one chunk to another in a > dbspace? Any pointers on how to do this would be greatly appreciated. > > Another approach I was thinking was to just create a new dbspace > altogether and use ALTER FRAGMENT. Would this be a better way to go? > > Ted Fiedler > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >