Upgrade to 8i

[monna]

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

[sjadhavdba]

use migration utilities

[denevge]

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

[nabaig]

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

[denevge]

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

[monna]

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


Thanks,to all

[pravin]

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