Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: change db_block_size ?

Re: change db_block_size ?

From: Kenneth C Stahl <BluesSax_at_Unforgettable.com>
Date: Thu, 08 Jul 1999 08:01:50 -0400
Message-ID: <3784932E.FEC660D4@Unforgettable.com>


The only way that you can do it is to export all of your user data, drop the instance and create a new instance with the correct block size. There is really no other option or shortcuts.

Ken

Timpie wrote:

> Hi there,
>
> I recently installed an Oracle 8.0.5 DB and fortunately I discovered
> that the db_block_size is wrong before
> any data is loaded. Cou8ld you oracle freaks tell me the quickest way
> to change the db_block_size of my
> database without having to reinstall the whole bunch all over again. I
> know it can be done but it's been a while
> since I done something with oracle.
>
> Thanks
>
> Tim
Received on Thu Jul 08 1999 - 07:01:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US