Re: Resizing block size under active database

You will not be able to open the database if you change the block size in the init<SID>.ora file. Like Eric said below, the ONLY way to change the block size in an exisiting database is ... you really can't. You have to create a new database, and start it with the new block size specified in the init<SID>.ora file.

Eric Hanson wrote:

> 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 - 12:09:50 CST