Re: Resizing block size under active database

From: Eric Hanson <ehanson_at_gr.com>
Date: Wed, 17 Mar 1999 09:21:24 -0700
Message-ID: <36EFD684.5330CF20@gr.com>

Hi,

The only way to change the block size of an existing database is to rebuild the database. Never having tried it I'm unsure what the result would be if you changed the block size within the init.ora file. With this being said, with 8i you will be able to have tablespaces with different block sizes.

Eric Hanson, DBA

Wee Chee Keong wrote:

> Hi,
>
> newbie to Oracle here. Will there be any problem if I modify the block
> size from 2k to 4 or 8k on my existing database? Thanks.
>
> WCK
Received on Wed Mar 17 1999 - 10:21:24 CST