Re: moving a database

This is a multi-part message in MIME format. --------------12DBBEAA452F865A238E0E20 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit "onload" utility given you the option to specify which dbspace to put your "onunloaded" databases and tables. If you don't specify, the databases and tables will be stored in rootdbs! Since you're going to load a 13gigs data, I would suggest you to use High-Performance Loader. Andy@my "Henderson, Scott" wrote: > Something to watch out for with onload. Detached indexes. Onload cannot > handle a detached index, the utility wants to put the index in the dbspace > from which it came. I believe this to be true on all platforms. > > Scott H. > > > -----Original Message----- > > From: bsagonda@my-deja.com [SMTP:bsagonda@my-deja.com] > > Sent: Thursday, November 11, 1999 5:24 AM > > To: informix-list@iiug.org > > Subject: moving a database > > > > > > > > hie guys i have the following setup on may database. > > The database is about 13gigs big, the problem is that i have 7 dbspaces > > and out of those 7 , three of them are made up of chunks using the > > actual physical name including the root dbspace. > > > > i want to use the onunload and onload utilities to export the entire > > database, my question to you is the when i want to load back the > > database will it remember which dbspace each table was located and put > > it there. > > > > I am hesitating to use the dbexport and dbimport becauze it could take > > me days to do it. > > > > Any help or suggestions will be appreciated. > > -- > > Blessing K. Sagonda > > Networks > > Ok Zimbabwe > > > > > > Sent via Deja.com http://www.deja.com/ > > Before you buy. --------------12DBBEAA452F865A238E0E20 Content-Type: text/x-vcard; charset=us-ascii; name="andykwl.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Andy Lau Content-Disposition: attachment; filename="andykwl.vcf" begin:vcard n:Lau;Andy tel;cell:+60 19 326 2014 tel;fax:+60 3 715 6940 tel;work:+60 3 715 6890 x-mozilla-html:FALSE url:http://www.logica.com org:Logica (Malaysia) Sdn Bhd version:2.1 email;internet:andykwl@pd.jaring.my title:Technical Support Engineer - PrePaid adr;quoted-printable:;;601, Level 6, Uptown 1, No. 1,=0D=0AJalan SS21/58, Damansara Uptown,;Petaling Jaya;;47400;Malaysia fn:Andy Lau end:vcard --------------12DBBEAA452F865A238E0E20--