Re: How configure block-size ?

From: N Prabhakar <n_prabhakar_at_post1.com>
Date: 1997/07/31
Message-ID: <01bc9d77$3b7edc50$725118d2@sin00119>#1/1

Hello there,

The only way to change the block size is to REBUILD the database. Take a export of your current database.

Edit init.ora which lies in ORACLE_HOME/dbs directory Change DB_BLOCK_SIZE to 8192 (This parameter indicates the block size for that instance)
Create the database
Import the data

This should work

Regards

N.Prabhakar

Guido Hansen <hansen_at_omega.gmd.de> wrote in article <5r9tjp$u6u_at_omega.gmd.de>...
> Hallo!
>
> Does anybody know how i can create a database with db_block_size = 8 K ?
> The UNIX-Installer of the ORACLE-Server 7.3.3 uses 2K as default value,
which
> is a waste of disk space. So far i couldn't tell the installer to use 8
K.
> What must i do to drop the database created by default and create a new
> database with the right db_block_size manually?
>
> thanks for any help
>
> Guido
>
Received on Thu Jul 31 1997 - 00:00:00 CDT