Re: Migrating database from 8.1.6 to 9.2

yvesj_at_optonline.net (Yves J.) wrote in message news:<cccf2934.0404210636.66fe8398_at_posting.google.com>...
> In the Oracle9i Database Migration Release 2 (9.2) manual, it is
> indicated that one cannot directly migrate a database from 8.1.6 to
> 9.2 (Table 2-1 Upgrade Paths).
>
> They instruct to first migrate the database to 8.1.7 "using the
> instructions in Oracle 8i Migration", THEN migrate to 9.2.
> There is no further help on where to find those instructions.
>
> My question is, do I need to buy the CD's corresponding to 8.1.7 to
> perform the migration 8.1.6 to 8.1.7 ?

No. Download the patch from metalink. The README says what you need to do, including a link to
http://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=188061.1

It's pretty simple, but be sure and look for additional patches for your situation. For me, IIRC I felt the need to patch export (Note:199416.1 Note:223399.1) and a couple of other things, and I found at least one situation where (inline update SQL) code broke going from 8.1.7.2 to 8.1.7.4 that was not documented anywhere that I could find.

Don't forget to post minimal information necessary to answer questions: http://members.cox.net/oracleunix/readme-cdos.htm

jg

--
@home.com is bogus.
Yeah, I was po'd when CA took away my extra overtime, too. 
http://www.signonsandiego.com/news/business/20040421-0554-overtimepay.html