Re: How to clone/copy a database ?

Hi,

You should be able to get away with copying all of your files to the new machine, providing Oracle is installed on the other machineand the name of the database is to remain the same. If path names are going to be different on the new machine, then you will have to edit your init file for the new path names for control files, dump files, etc. Then you will have to use Alter DB to change the path names of your data and redo files. All in all it should be a far cry quicker then creating the database and using exp/imp.

Rob
medleyrk_at_iafrica.com

> Folks,
>
> I am trying to clone an existing database on another machine in an
> efficient and less time consuming path. Could someone help me with a
> list of steps I have to ollow in order to achieve my goal.
>
> Even though I could create a new database, on the new machine, create
> all necessary tablespaces, export the entire DB from the existing
> instance and import onto the new database, I am looking for a solution
> something similar to copying the datafiles, controlfiles, and
> activating the new database.
>
> Thanks very much.
Received on Wed Jan 27 1999 - 15:15:26 CST