Home » RDBMS Server » Server Utilities » Migrate from Oracle 8.0.3 (Netware) to oracle 8.1.7 (WIN2K)
Migrate from Oracle 8.0.3 (Netware) to oracle 8.1.7 (WIN2K) [message #72439] Tue, 17 June 2003 06:57 Go to next message
mirsa
Messages: 1
Registered: June 2003
Junior Member
PLZ, can someone give me the best way to migrate an oracle database 8.0.3.0 Entreprise edition installed on a NOVELL NETWARE 5 server to a 8.1.7 on win2K.
Thanks
Re: Migrate from Oracle 8.0.3 (Netware) to oracle 8.1.7 (WIN2K) [message #72440 is a reply to message #72439] Tue, 17 June 2003 07:12 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
1. install 8.1.7 in windows.
2. create tnsentries in the tnsnames.ora of source (8.0.3)
   so that you can connect 8.1.7 in windows.
3. take a full backup of 8.0.3
4. take a full database export of 8.0. or selected schemas (login as dba )
[b]
exp username/password@source other_options
[/b]
5. Create the tablespaces and users in 8.1.7
    with the same name as in 8.0.3
6. from source ( u have to use lower version of exp and imp, so using 8.0.3 exp and imp tools)
    now import into target
[b]
imp username/password@target other_options
[/b]

Previous Topic: Error in Rollback segment creation in 9i in a non system tablespace
Next Topic: Changes required for Installing multiple databases?
Goto Forum:
  


Current Time: Tue May 28 14:13:00 CDT 2024