Re: Resizing block size under active database

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Wed, 17 Mar 1999 16:52:15 +0800
Message-ID: <36EF6D3F.4386@bhp.com.au>

Wee Chee Keong 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.
>
> WCK
Unfortunately you need to unload the database (exp full=y), recreate the database with the new block size and reload.....

--

---

Connor McDonald
BHP Information Technology
Perth, Western Australia
"Never wrestle a pig - you both get dirty and the pig likes it..." Received on Wed Mar 17 1999 - 02:52:15 CST