upgrade

[cravi]

Hi Guys

can you tell me how to upgrade from oracle 7.3.4 database to 8.0.5 on Nt 4.o environment.

Thanks and Regards
Ravi

[sreddy]

The best approach I follow is full exp/imp unless otherwise you have limitations of size of the database.

1Set ORACLE_SID=sid_name
2Check for the count/status of the objects before exp
3exp system/xxxx buffer=99999 full=y
4Ftp the dump file in Binary form to the location where you want to import
5Precreate the tablespcae structures that match with the structure of database you are trying to import
6imp sytem/xxxx buffer=xxxx ignore=y full=y
7Check for the count/status of the objects after imp
8 Recompile all the objects and make sure you didn't miss any.
9 You should be ok at this point.
10 You can rerun your catalog/catproc to update all the procedural options and data dictionary.

Check for the actual syntax options of EXP/IMP and how you want control your exp/imp.

Feel free to e-mail me if you need anyscripts to check objects count/status etc.,

Exceptions are:
If your 732 database use LONG/LONG RAW.
It fails and you need to export that table seperately with large buffer size/max allowable buffer size. If that also fails I guess you need to write a program to extract that data and load into v8 database.

[Edited by sreddy on 12-21-2000 at 11:29 PM]