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?
8i OCP DBA
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
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
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.
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.
Denevge, did you use Migration Utility or Oracle Data Migration Assistant?
Did you encounter any bugs, problem while migration?
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. ?
Click Here to Expand Forum to Full Width