RE: Moving database between dbspaces

HPL or the dbcopy utility would possibly be useful. -----Original Message----- From: musman@my-deja.com [mailto:musman@my-deja.com] Sent: Tuesday, January 23, 2001 7:19 AM To: informix-list@iiug.org Subject: Moving database between dbspaces Hi I would like to move one database from one dbspace to another dbspace. Is ther any command line utility without performing backup. Can we use onunload & onload with pipe. muhammad usman musman@iffco.com Sent via Deja.com http://www.deja.com/

In article <94kn0c$410$1@news.xmission.com>, John Carlson <John_Carlson@whsmithusa.com> writes > You can use alter fragment on table x init in dbspace1. to move individual tables but of course system catalogs should not be moved, and new tables will by default be created in the old dbspace. Still it is quickest (remember to take transaction logging off first!) and does not require space for an unload. >HPL or the dbcopy utility would possibly be useful. > >-----Original Message----- >From: musman@my-deja.com [mailto:musman@my-deja.com] >Sent: Tuesday, January 23, 2001 7:19 AM >To: informix-list@iiug.org >Subject: Moving database between dbspaces > > >Hi > >I would like to move one database from one dbspace to another dbspace. >Is ther any command line utility without performing backup. Can we use >onunload & onload with pipe. > > > >muhammad usman >musman@iffco.com > > >Sent via Deja.com >http://www.deja.com/ -- David Williams