Re: How configure block-size ?

In unix to create a new database instance 1 - build a new initSID.ora file with the db_block_size of your choice. 2 - write a sql script that does a create database (called create.sql in this example)
3 - write a sql script to build the rest of your database (rollbacks, and other tablespaces as needed)
4 - set your ORACLE_SID to the new sid name. 5 - run 'svrmgrl', connect internal, do the startup mount with pfile option (=create.sql)
6 - run your build script, shutdown, startup and your on your way

Guido Hansen wrote:

> 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

--
eric kamradt
hm: (801) 567-0912
mailto: kamradt_at_inconnect.com
http://www.inconnect.com/~kamradt/resume.html