Re: Altering DBSPACE

Posted in 2000

Vinod Bhansali — Tue, 30 May 2000 19:22:22 GMT — source: Informix-list mailing list archive (1991-1998)

Try "Alter fragment on tab-name init in dbspace" Vinod Bhansali >From: Raymond Michalek <rfm@tpso.com> >Reply-To: Raymond Michalek <rfm@tpso.com> >To: informix-list@iiug.org >Subject: Altering DBSPACE >Date: Sun, 28 May 2000 16:38:02 +0200 > >Hello group, > >We have created all of our tables in dbspace "st_ux01_001". >Now the "dbadmin" want to move all of our tables to dbspace >"st_ux01_002". > >In Informix dokus we didn't find any command to alter a dbspace. > >The only way we know to alter the dbspace is, to export all data >an recreate the dbschema with the new dbspace and then reimport all >data. > >Does anyone know an altarnative to this? > >Thanks for your answers > >Raymond > > > ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com