How to move database to another machine?(i20)


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 ....



Ans1:

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
 
 

Hosted by www.Geocities.ws

1