Upgrade to 8i

Hi,
Soon I have to upgrade oracle from 7.3 to 8i on Windows NT (for the first time)
Size of db=85 GB
Could you please give me some steps to keep in mind and /or some documentation to?
Read before


Thanks

use migration utilities

In the oracle documentation, you have the migration guide which gives you an excellent overview of the steps to be taken.
You can find this guide at
http://otn.oracle.com/docs/products/...a86632/toc.htm

When you choose for export/import, the duration of the migration is determined by the size of the data in your db.

When you choose for migration, the duration of the migration is determined by the number of objects your db contains.

Hope this helps
Gert

I dont think that you can migrate using the MIG utility directly from 7.3 to 8i. You first have to move to version 8.0.4 and then to 8i.

I belive your DB size is 85GB. Import/Export will be too time consuming.

Nizar

In the migration guide you will find the procedure to migrate the db from 7.3.4 -> 8i.

You don't need to pass by 8.x .

I've done it several times on NT and AIX.

Regards
Gert

Denevge, did you use Migration Utility or Oracle Data Migration Assistant?
Did you encounter any bugs, problem while migration?


Thanks,to all

see correct me if i just wanted to have my thought on migration clear
in this same scenario 7.3.4 to 8.1.7

see when u decide to do migration by exp/imp

first take a export backup of database with full=y
u install oracle 8.1.7
create the database /run the data dict srcipts / create temp,rollback,users tablespaces / datafiles , users .
then import the backup. am i right ? or missing something .

is there any sql conversion script to run. ?

-- pravin