Re: Oracle 9.2 Upgrade Question

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: http://www.orafaq.com
-- 
Author: Charlie Mengler
  INET: charliem_at_mwh.com

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: ListGuru_at_fatcity.com (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).