Re: Upgrade Oracle 9i to 10g from 4096 to 8192 db block size
From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Fri, 05 Dec 2008 20:26:38 +0100
Message-ID: <6ptdjfF9t710U1@mid.individual.net>
>
> Using exp/imp you could easily do this; it won't be possible with an
> upgrade in place. Create your 10.2.0.3 database with an 8k block size
> and import your 9.2 data.
Date: Fri, 05 Dec 2008 20:26:38 +0100
Message-ID: <6ptdjfF9t710U1@mid.individual.net>
On 05.12.2008 18:45, ddf wrote:
> On Dec 5, 11:18 am, Kaka <kaka...._at_gmail.com> wrote:
>> Is it something feasible? i have 9i running 4096 db block size and my >> goal is to do an upgrade to 10g and db block size 8192. thanks!
>
> Using exp/imp you could easily do this; it won't be possible with an
> upgrade in place. Create your 10.2.0.3 database with an 8k block size
> and import your 9.2 data.
OP, you might even be able to do a direct copy via a database link - if you have enough resources to have both instances up at the same time.
Cheers
robert Received on Fri Dec 05 2008 - 13:26:38 CST