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: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/04/10
Message-ID: <955363148.24789.0.pluto.d4ee154e@news.demon.nl>#1/1

Reinstalling the software is unnecessary, recreating the database is unavoidable, by the nature of the internal physical layout of Oracle.
All header blocks will be resized, so there's no other way.

Regards,

Sybrand Bakker, Oracle DBA

"Duarte Nuno Sousa" <Duarte.Sousa_at_solsuni.pt> wrote in message news:38F194FB.73A651EB_at_solsuni.pt...
>
>
> I'm wondering if there is any other option to change de DB_BLOCK_SIZE in
> a DataBase without reinstaling all.
> I' m running Oracle 8.0.5, and i want to increse the DB_BLOCK_SIZE to
> 8k.
>
>
> Duarte Nuno de Sousa
> duarte.nuno_at_solsuni.pt
>
Received on Mon Apr 10 2000 - 00:00:00 CDT

Original text of this message

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