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

From: Andrew Babb <andrewb_at_mail.com>
Date: Tue, 20 Apr 1999 12:24:32 +0800
Message-ID: <371C0180.851FD295@mail.com>

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

agichen_at_my-dejanews.com wrote:

> Hi,theres, I must duplicate a db to another machine on Dec UNIX. (both are
> on UNIX) And I also want to enlarge the db_block_size, is exp/imp the only
> one way ?
>
> If only copy a db to a different machine without changing db_block_size,
> what' the fastest way ?
> you know that exp/imp is time coneuming ....
>
> Rgds.
> Agi
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon Apr 19 1999 - 23:24:32 CDT