Re: Moving database to another server

I can't help on the unix part, but to move the database the most straightforward way would be to do a full export, set up the new database on the new server and import

Another way, given sufficient resources, would be to set up the new server and database, connect to it from the old one and copy the required files using the sql copy command or the create as select * from construct. The export/import method is the one I would use--- It will allow you to clean up, consolidate and otherwise set up the new database the way you want it.

HTH,
John Greco  

 Carlos A. Gonzalez wrote in article <01bc491a$eee9ac40$8a1ca68f_at_carlos.us.d ell.com>...
>
>Oracle Gurus:
>
>I need your help
>
>I must move a database to another server.
>
>How do I go about it. How do I keep my control files straight ??
>
>Also is it to my advantage to use raw devices instead of file
 systems(Unix)
>??
>
>Any help will be appreciated.
>
>Thanks
>
>Carlos
>
Received on Tue Apr 15 1997 - 00:00:00 CDT