Home » RDBMS Server » Server Utilities » Migration of data from Oracle 7.3.4 to Oracle 8.1.6 (64 bit)
Migration of data from Oracle 7.3.4 to Oracle 8.1.6 (64 bit) [message #368418] Mon, 18 December 2000 03:33 Go to next message
Biraja
Messages: 6
Registered: December 2000
Junior Member
My requirement is to migrate Oracle7.3.4 database to Oracle 8.1.6 database. If I will export the data from Oracle7.3.4 and import the dmp to Oracle 8.1.6, will it work properly in Oracle 8.1.6 ? Please do guide me to migrate the oracle 7.3.4 database to Oracle 8.1.6 (64bit). Expecting early solution please...

Regds
Biraja
Re: Migration of data from Oracle 7.3.4 to Oracle 8.1.6 (64 bit) [message #368419 is a reply to message #368418] Mon, 18 December 2000 08:16 Go to previous message
Bala
Messages: 205
Registered: November 1999
Senior Member
Hi Biraja,

There are three ways you can migrate from 7.3.4 to 8.1.6
they are
1.exp/imp
2.migration utility
3.migration assistant.

The second and third methods can be used only when migration takes place in the same platform(os)........

Out of these three i prefer migration utility, which is faster, easier and highly recoverable.

If your database is not very big then export and import may be a good solution and if you doing crossplatform thats the only way you can go with...
visit this link for a detail manual for migration.
http://oradoc.photo.net/ora816/server.816/a76957/migintro.htm

Bala.
Previous Topic: SQL Loader Max Limit 258?
Next Topic: Oracle Data Storage
Goto Forum:
  


Current Time: Tue Apr 23 11:14:36 CDT 2024