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: Resizing block size under active database

Re: Resizing block size under active database

From: James Petts <jpetts_at_celltech.co.uk>
Date: Wed, 17 Mar 1999 08:46:54 GMT
Message-ID: <36ef6bc2.88932287@firewall.celltech> 





It can't be done. You must recreate the database with the new block
size. The block size is so fundamental to the structure of the
database that it gets used in too many places for a change to be
feasible.



James Petts



On Wed, 17 Mar 1999 09:45:10 +0800, Wee Chee Keong
<abramswee_at_pacific.net.sg> wrote:



>Hi,


>


>newbie to Oracle here. Will there be any problem if I modify the block


>size from 2k to 4 or 8k on my existing database? Thanks.



Received on Wed Mar 17 1999 - 02:46:54 CST












Original text of this message













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