Upgrade from 7.3.2 to 9i database

[rdalvi]

We are currently running Oracle 7.3.2 database in Windows NT 4.
We are planning to move the database to Oracle 9i on Windows 2000 server.
What are the steps involved ? Should I have to use any migration tools ?
please guide.

Richard
India

[aarroyob]

In your case the quickly way is export/import.

Cheers

Angel

[kolagani]

Richard:

You are currently running 7.3 and migrating to Oracle 9i. There are basically six steps you have to go through.

1) Prepare to Migrate
2) Test the Migration process
3) Test the Migrated Database
4) Prepare and preserve the Source Database
5) Migrate the production Database
6) Tune and adjust the Oracle 9i Production Database

Depending on your 7.3 release version you have four options. If it is the last release of 7.3 you can use Migration Utility. You cannot use Oracle Data Migration Assistant because you are changing the operating system. However, you can use either Export/Import or Data Copy methods. Data copy methods require that you have both the instances available during copying the datafiles.

If you decide to use export/import you need to be aware of the high time and system resource requirements (especially disk space). Oracle 9i binaries may require as much as three times of the disk space required by 7 binaries. CPU requirements may be doubled.

Check for the use of ROWIDs in both user columns and packaged code. The format of ROWIDs is different in 9i. Do not open the database between running the migration and executing the ALTER DATABASE CONVERT statement. Prepare a backup strategy and develop a testing plan. Be aware of the fact that many of the initialization parameters are added/renamed/deprecated in 9i.