Re: Q: How to move a table(s) + index(s) to a new dbspace

Gee, I've been suggesting this soo much lately, I feel like a broken record - look at the SQL "Alter Fragment ... Init" in the SQL guide. Works great. Endorsed by Art Kagel. It doesn't get any better. Gregorio... Susan Elliott (ISG) wrote: > > Howdy folks, hopefully and easy one for someone. > > Normally I use the application to export and reimport tables, I would > like to do it at the informix level. > Currently we have 2 dbspaces, one for indexes and one for data I need to > move some tables and matching indexes out of these and into another > dbspace called archive. Would someone please advise what would be the > best way for me to do this ? > > Thanks > Suze.