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: Thu, 11 Oct 2001 19:08:55 +0200
Message-ID: <tsbld2ovlhgt98@news.demon.nl> 






"Tuan Dang" <tdang1_at_slb.com> wrote in message
news:9q4hsc$m8h$1_at_news.sinet.slb.com...


> Hello,

>

> Does anybody know how to change the oracle parameter db_block_size?

>

> Thanks,

> Tuan

>




Sigh, no version.



In Oracle 9i I'm not too sure


Before 9i:


export the database


shut the database


change the init.ora  parameter db_block_size
*recreate* the database


perform an import



Hth,


Sybrand Bakker


Senior Oracle DBA
Received on Thu Oct 11 2001 - 12:08:55 CDT












Original text of this message













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