Home -> Usenet -> comp.databases.oracle -> Copy Oracle 7.2.2.4.0 Instance from one NT Server to another

Copy Oracle 7.2.2.4.0 Instance from one NT Server to another

From: Martin Schultz <martin.schultz_at_virgin.net>
Date: 1999/01/06
Message-ID: <770k0s$37p$1_at_nclient3-gui.server.virgin.net>#1/1 






I want to copy an Oracle 7.2.2.4.0 Instance from an NT 3.5.1 Server to an NT
4 Server.



The method I propose using is as follows :-



(a)    Create an instance on the target server using the source initorcl.ora


parameter file.



(b)    Create tablespaces with the correct names and dimensions, and


rollback segments on the target instance - this is necessary because the
target server has a different hardware configuration.



(c)    Take a full export of the source instance using "exp72 file=FULL.DMP


log=FULL.LOG FULL=Y"



(d)    Import FULL.DMP into the target instance using "imp72 file=FULL.DMP


log=FULL.LOG1 FULL=Y IGNORE=Y"



(e)    Run Catalog.sql and CatProc.sql.





Please could someone confirm this is the correct procedure OR correct me as
this is rather a long drawn out process to get wrong !



Many thanks.


--
Martin Schultz
MSTech Limited
e-mail: martin.schultz_at_virgin.net


Received on Wed Jan 06 1999 - 00:00:00 CET












Original text of this message