RE: Moving database between dbspaces

Hello, One way is to use DBEXPORT, then rename the existing database (if you have space as a backup), DBIMPORT to the new dbspace location, then delete the old database. The High Performance Loader is another option. It all depends on the size of the database. All options are explained in the Informix Migration Guide, which may be in your interest to read. All the best, Peter __________________________________ Peter Marley Data Warehouse Developer, Acco Europe Tel: +44 (0)1296 732184 Fax: +44 (0)1296 732185 email: peter.marley@acco-uk.co.uk <mailto:peter.marley@acco-uk.co.uk> -----Original Message----- From: musman@my-deja.com [SMTP:musman@my-deja.com] Sent: Tuesday, January 23, 2001 12:19 PM 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/