Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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 ?
if the database is not large, why not just use export / import and move the data into a newly created 9.2.0.5 database?
use the 8.1.6 export utility (compress=N, statistics=NONE) to create the dump file and use the 9.2 import utility.
This way you'll have all LMT tablespaces and not have to convert a DMT SYSTEM tablespace into an LMT one.
Pd Received on Wed Apr 21 2004 - 18:59:49 CDT