Q

Migrate to 9.2.0.7 first or directly to 10g?

We are currently running Oracle 9i (9.2.0.1). We are considering going to 10g. Can we migrate directly to 10g or do we have to go to 9.2.0.4 or 9.2.0.7 before we go to 10g? Also, our current applications don't really need any of the new functionality in 10g -- so is there a good reason to migrate there, other than to be current?

We are currently running Oracle 9i (9.2.0.1). We are considering going to 10g. Can we migrate directly to 10g or do we have to go to 9.2.0.4 or 9.2.0.7 before we go to 10g? Also, our current applications don't really need any of the new functionality in 10g -- so is there a good reason to migrate there, other than to be current?

If you are planning to upgrade from Oracle9i Release 2 to Oracle 10g Release 2, you must be at Oracle 9.2.0.4 or

higher to go directly to 10gR2. This information can be found in the Oracle Database 10g Release 2 (10.2) Upgrade Guide.

If you do not want to first patch your 9i binaries to 9.2.0.4, you can investigate using export and import to upgrade your database to 10g. This choice would depend on how large your database is. If you have a fairly small database, using export and import may be a good choice.

There are many new features in Oracle 10g which you might want to read about in the Oracle Database 10g Release 2 (10.2) New Features Guide.

Even though you may not be able to utilize many of the new features in 10g, it is a good idea to remain at a supported database release. Having said that, it appears that Oracle 9.2 now has extended support until July 2010 and 10gR2 until July 2013. Click here for more information about Oracle's lifetime support policy.

This was first published in June 2006

Dig deeper on Oracle database installation, upgrades and patches

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close