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

Posted in 1998

Susan Elliott (ISG) — Wed, 26 Aug 1998 13:12:23 +1200 — source: Informix-list mailing list archive (1991-1998)

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.