Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How configure block-size ?
Guido Hansen 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
Yes. If you have an existing database for which you wish to change the block size you will have to: export the current database, recreate it with the new block size, and then reimport.
Steve Phelan. Received on Fri Jul 25 1997 - 00:00:00 CDT