Re: Upgrade Oracle 9i to 10g from 4096 to 8192 db block size

From: Robert Klemme <>
Date: Fri, 05 Dec 2008 20:26:38 +0100
Message-ID: <>

On 05.12.2008 18:45, ddf wrote:
> On Dec 5, 11:18 am, Kaka <> 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 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

Original text of this message