Re: DB_BLOCK_SIZE --- How ??

Hi Steve:

    I have to disagree. With 8.1.5 and 8.1.6 the database creation assistant allows you to edit quite a few settings for your sample database (named whatever you want) as well as choose where your datafiles will go and what they'll be named. The assistant takes care of a great deal of housekeeping and minor script running. When it is finished you have a running database that can be modified in whatever way you wish - more tablespaces added, init.ora parameters changed, etc. etc.

    We create all our databases with the assistant these days then modify them afterwards. It saves us more than half the time it takes to create one by hand.

Van

Steve Jones <steve.jones_at_takethisoutproact.net> wrote in message news:3935234c.0_at_nnrp1.news.uk.psi.net...
> You can't change DB_BLOCK_SIZE after a database has been created. It must
 be
> done before. However, most of the install scripts make a (not well set up)
> default database called ORCL. This is not really suitable for the real
 world
> because DB_BLOCK_SIZE is wrong, everything is likely to be on the same
 disk
> (not a good idea if a head crash happens), all objects default to the
 system
> tablespace (not a good idea - much better to create tablespaces for
 rollback
> segements, users, temp etc.). Anyway, for all these reasons, it's better
 to
> make a proper DB after the installation is done.
>
> If you do this, before making the DB, it is customary to copy the
> INITxxxx.ORA file to INITnewdb.ORA and edit the parameters. In this case,
 I
> would change DB_BLOCK_SIZE to be 4 or 8 or 16k, set the DB to do automatic
> archiving etc., then run the create database command in SVRMGRxx, or use
 one
> of the GUI tools to accomplish the same thing.
>
> --
> Steve Jones
> stevej_at_getridofthisproact.net
> Johnson <syner_at_pd.jaring.my> wrote in message
> news:8h2kmg$era$1_at_news4.jaring.my...
> > Hello,
> >
> > How am I going to make this DB_BLOCK_SIZE to 16K in windows NT server.
> > During install, the database ORCL is created and the db_block_size is
> > default to 1k.
> >
> > Do I change db_block_size during Oracle Installation or after the
> > installation. How ??
> >
> >
> >
> >
>
>
Received on Wed May 31 2000 - 00:00:00 CDT