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: DB_BLOCK_SIZE: Misinformation?

Re: DB_BLOCK_SIZE: Misinformation?

From: Vitaly Sikolenko <vsikolen_at_ru.oracle.com>
Date: 1997/08/08
Message-ID: <33EB11D1.4DAA3F69@ru.oracle.com>#1/1

SatarNag wrote:

> In regards to changing the DB-Block_Size without re-creating your
> database, I must have been misinformed, Upon looking up in my
> documentation, it says it must be done on the creation of the
> database. I
> have just completed the Oracle DBA master's coarse (Oracle 7.3),
> offered
> by Oracle....And in my notes, i wrote down that the Block Size can be
> changed and that the database will start useing the new size and will
> adjust accordingly...I wrote this down cause I thought it was nice
> that it
> can be done. Maybe it still can be done, and that it's not documented
> in
> the books. I apoligize if I am mistaken. Maybe it's in Version 8???
>
> Satar Naghshineh

  You can't change the db_block_size: it would lead to full restructuring of the database.

--
Vitaly Sikolenko                  Senior Sales Consultant
                                  Server & Gateways
ORACLE C.I.S.
Moscow Russia                      E-mail: vsikolen_at_ru.oracle.com

The statements and opinions expressed here are my own and do not
necessarily represent those of Oracle Corporation.
Received on Fri Aug 08 1997 - 00:00:00 CDT

Original text of this message

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