Re: Changing the block size

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 05 Jan 1999 19:51:20 +0100
Message-ID: <36925F27.D52762FC@sybrandb.demon.nl>

Yes, there is

- export the database
- recreate the database with the new block size as per the init<sid>.ora
- import the database

There are numerous internal structures (table directories, row directories) which are directly depended from the block size. The block size can't be changed without recreating the database. NB: db_block_buffers is measured in blocks, not in k's

Hth,

Sybrand Bakker, Oracle DBA

Zachary Agatstein 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.

Received on Tue Jan 05 1999 - 12:51:20 CST