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

Alter fragment can be an expensive operation - especially on your logicallogs. 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