Re: moving a database

From: bsagonda@my-deja.com > >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. Days? Jeeze, what are you using to move the data across? Floppy disks? :-) I just did a 5GB dbexport/dbimport to tape migration in 3 hours, end to end. If I'm given the choice, I *always* use dbexport/dbimport, followed by a tasteful UPDATE STATISTICS. I'm sure onunload/onload will be able to put things back in the right places, provided you have defined them correctly. Or you could use ontape or onbar. But I'd go with dbexport/dbimport. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com