Re: Upgrade Oracle 9i to 10g from 4096 to 8192 db block size
Date: Fri, 05 Dec 2008 20:26:38 +0100
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.
robert Received on Fri Dec 05 2008 - 13:26:38 CST