Re: Changing the block size

You cann't simply change the db_block_size in init.ora parameter file after a database is created. For changing the db_block_size you will have to recreate the entire database. DB_BLOCK_SIZE at the time of database creation is used to format datafiles as per the block size and so if DB_BLOCK_SIZE gets changed all the existing datafiles will become unusable for new DB_BLOCK_SIZE. That is why you will to recreate the entire database.

To achieve this you need to first export the database, recreate the database with new DB_BLOCK_SIZE, and then import the export file.

Hope this helps,

Manoj Jain
Oracle Certified Professional DBA
Chauncey Certified Oracle7 DBA

In article <76ticl$220s2_at_tmpsp002.tmpprv.allied.com>,   "Zachary Agatstein" <Zachary.Agatstein_at_atsc.allied.com> wrote:
> I tried to increase the database block size from 2k to 4k, by changing a
> parameter in initxxxx.ora file, and rebooting the system. The database,
> however, has been populated. It gave me an error and prevented from
> mounting an instance. Is there a way to do it?
>
> Many thanks in advance.
>
> Zach A.
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Jan 06 1999 - 10:12:29 CST