Re: change db_block_size ?

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