Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DB_BLOCK_SIZE: Misinformation?
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