Re: Copy a db to a different machine.....

From: Bass Chorng <bass_at_octel.com>
Date: 20 Apr 1999 20:35:51 GMT
Message-ID: <7fiof7$cde$1@news.eng.octel.com>

Andrew Babb (andrewb_at_mail.com) wrote:
: To change the Oracle Block size, on any Oracle version requires a full unload
: and load (exp/imp). If you just want to move the database from one machine to
: another, this can be achieved with normal UNIX commands such as rcp or ftp.

: You need the same directory structure on the target machine, or be prepared with
: a big rename datafile on the target machine. Also, the OS's should be at the
: same release (including patch level) for safest copying.

: Rgds
: Andrew

If I may add one comment here: You dont have to have the same directory structure on the target machine. You can rebuild your controlfile where you can specify your new paths and new database name. Controlfiles rebuild script can be generated by 'alter database backup controlfile to trace' on the source database.

Regards,
Bass Chorng Received on Tue Apr 20 1999 - 15:35:51 CDT