Re: Export 8i database to 10g version
From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Sat, 14 Jan 2012 11:11:46 -0300
Message-ID: <CAJ2dSGSf5jsBk7V8r9taY4sxbx1rec0ONPKg7_he0G4gPJybFQ_at_mail.gmail.com>
check mOS for certified upgrade path, I think 8i to 10.1 is supported, and I expect 8i to 10.2 would be as well. If it is supported you can either use DBUA, upgrade scripts (catupgrd) or export import. IF you choose to use export import I suggest you create the tablespaces AND users beforehand, 8i users could have "system" as their temp tablespace, starting with 9i you need a dedicated tablespace for temp. Also, I suggest you read up on upgrade and migration if this is a critical database because there are a few pitfalls to look out for.
hth
Date: Sat, 14 Jan 2012 11:11:46 -0300
Message-ID: <CAJ2dSGSf5jsBk7V8r9taY4sxbx1rec0ONPKg7_he0G4gPJybFQ_at_mail.gmail.com>
check mOS for certified upgrade path, I think 8i to 10.1 is supported, and I expect 8i to 10.2 would be as well. If it is supported you can either use DBUA, upgrade scripts (catupgrd) or export import. IF you choose to use export import I suggest you create the tablespaces AND users beforehand, 8i users could have "system" as their temp tablespace, starting with 9i you need a dedicated tablespace for temp. Also, I suggest you read up on upgrade and migration if this is a critical database because there are a few pitfalls to look out for.
hth
cheers
Alan.-
On Fri, Jan 13, 2012 at 9:18 PM, Eriovaldo Andrietta <ecandrietta_at_gmail.com>wrote:
> Hi Friendes,
> I need to plan an activity in order to migrate a database from Oracle 8i
> to Oracle 10g, maybe 10.2.0.x.
>
> I have in my mind that I need export using exp (8i version) and import
> using imp (10g version).
> Is it correct ?
>
> Is there any special thing to pay attention ?
>
> Regards
> Eriovaldo
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Jan 14 2012 - 08:11:46 CST