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

Susan, Presuming that you're doing this during some form of system outage, (ie no users on the system trying to access this data), I would suggest: 1. Drop the indexes. 2. Move the tables using ALTER FRAGMENT ON TABLE table_name INIT IN archive_dbspace; Which effectively just moves the data from one dbspace to another. 3. Rebuild the indexes (and statistics) Whilst you can do it, I usually find it's more efficient to drop and recreate the indexes than to try and move them. cheers RET > ---------- > From: Susan Elliott (ISG) > Sent: Wednesday, 26 August 1998 11:12 > To: 'Informix Mailing List' > Subject: Q: How to move a table(s) + index(s) to a new dbspace > > 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. >