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

    Login

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

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top