We work with an Oracle 8.0.5 database. What would be the best way to migrate that database to Oracle 8i or 9i? The applicaction that uses the Oracle database is coded on Power Builder.
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
- Dozens more answers to tough Oracle questions from Brian Peasland are available.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.