Ask the Expert

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?

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: