Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle 9.2 Upgrade Question

Re: Oracle 9.2 Upgrade Question

From: Charlie Mengler <>
Date: Wed, 07 Aug 2002 17:48:22 -0800
Message-ID: <>

My reality seems to be different than what is stated below. While I have not yet converted/upgraded/migrated my real life production V7.3.4.5 instance to 9i, I HAVE taken copies of it directly from V7.3.4.5 to both 9i R1 & 9i R2 on practice systems numerous times without any hint of problems. Never once did I make any intermediate migrate/upgrade to 8.0.6, 8.1.7 or 9.0.1.

In fact, now that I think about my environment about 4 - 6 months ago I upgraded a V7.3.4.5 data warehouse instance directly to 9.0.1 where it remains today. Again I've had no problems with using odma & having a successful upgrade. Using odma to upgrade the 150GB datawarehouse took less than TWO hours to complete. FWIW - after the upgrade we ANALYZEd everything to complete the job and this effort took 12 - 16 hours to complete.

HTH & YMMV! "Molina, Gerardo" wrote:
> Also, Metalink has a good doc on this.
> Note 159657.1 Complete upgrade checklist for manual upgrades from 8.X to
> Oracle 9i (including 9.2)
> I would recommend a manual upgrade (ie., do not let installer upgrade your
> database).
> Keep in mind that there are only 3 migration paths to 9.2 - from 8.0.6,
> 8.1.7, and 9.0.1. If you are one another version, then you have to first
> upgrade to one of these versions before trying to upgrade to 9.2.
> HTH,
> Gerardo

Please see the official ORACLE-L FAQ:
Author: Charlie Mengler

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Wed Aug 07 2002 - 20:48:22 CDT

Original text of this message