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
