Re: Db_block_size

From: Rachel Carmichael <carmichr_at_hotmail.com>
Date: Thu, 08 Jun 2000 10:28:00 GMT
Message-Id: <10522.108194@fatcity.com>

well you can, sort of. Full database export, trash the existing database, rebuild it with the new block size, remember to adjust the init.ora parameters that will be affected by the new block size, full database import

But it is NOT elegant or quick. Makes a good case for PLANNING before you actually build anything.

Rachel

>From: guy ruth hammond <grh_at_agency.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: Db_block_size
>Date: Thu, 08 Jun 2000 00:56:08 -0800
>
>Eric Fang wrote:
> >
> > I tried to increase the db_block_size from 8k to 16k.
> > What's the maximum block size allowed on NT 4
> > serverice pack 5 and Soloris 2.4. Thanks.
>
>Eric,
>
>You can't change the block size after a database has been created.
>
>g
>
>
>
>--
>guy ruth hammond <grh_at_agency.com> | One is punished for being
>Technology Analysis & Consulting | weak, not for being cruel.
>07879607148 http://www.agency.com | -- Baudelaire
>
>
>--
>Author: guy ruth hammond
> INET: grh_at_agency.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).

---

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com Received on Thu Jun 08 2000 - 05:28:00 CDT