Forum OpenACS Q&A: Re: Moving Oracle to a new server

Posted by Andrew Grumet on
I haven't tried the file copy approach, so can't make any comparative statements, but I have used the exp/imp approach numerous times with success. About two weeks ago we did this for a database with a 17GB dbf file. The export and network file transfer were fast compared to the import, which took about 10 hours on a Sun Ultra-4 with 4GB ram. The web site in question doesn't rely heavily on Intermedia, but I have also had success in the past with Intermedia objects. It sounds from your post like you tried it and it failed. Perhaps exporting in full database mode would help.