Re: Change db_block_size

Yes, it's extremely easy. You open up the init.ora in a text editor of your choice, and you use normal editing commands to change the value the parameter is set to. Save your work, and you're done.

Oh.... you mean that you'd actually like the database to be opened successfully AS WELL???!

Afraid that's the difficult bit. It can't. It's been a feature of Oracle for the past, oh, 20 years or so that once the block size is set, it is set for good. That remains true in 9i, too.

So, you'll have to create a new database of the right block size, and use export and import to transfer your data across.

In 9i, you have the option to add in tablespaces of different block sizes than the one you started out with, but that probably isn't what you're after.

Regards
HJR "Tuan Dang" <tdang1_at_slb.com> wrote in message news:9q4hsc$m8h$1_at_news.sinet.slb.com...
> Hello,
>
> Does anybody know how to change the oracle parameter db_block_size?
>
> Thanks,
> Tuan
>
Received on Thu Oct 11 2001 - 16:28:50 CDT