EXPERT RESPONSE
The "best" way to migrate from 8.0 to 9i depends on
many factors. Chief among them is the size of the
database.
If I recall correctly, in order to go from 8.0 to 9i, you need to
upgrade to 8i or 8.0.6 first. So if you want to use
the upgrade scripts to upgrade your database, you will
have to do this in two steps. Each step is not a
particularly long step. If your database is
sufficiently large, you will want to employ this
method. The amount of time to process the upgrade
scripts is not necessarily dependant on the database
size. So a 1TB database can be upgraded quickly this
way. If you do not want to manually perform these
steps, you can use the Database Migration Assistant to
perform the upgrades for you. But you'll have to
install either Oracle 8.0.6 or 8i software on your
machine for the first upgrade step.
Another method is to export/import your database.
Export your 8.0.5 database. Then, remove that database
and create a brand new instance with the 9i software.
You now have a clean, fresh database. Then, import the
dump file created above. The migration will be
complete. This method can take a real long time if
your database is large. With the export/import method
of upgrading, the database size directly influences
the upgrade time. But with this method, you can change
your block size, reorganize your database, and fix
chained and migrated rows of data. This may be
important to you.
In either case, I strongly suggest that you thoroughly
read the Oracle 9i Migration Guide before you proceed.
As another tip, make sure to take a backup of your
database immediately before the migration, and
immediately after the migration is complete.
For More Information
|
