Re: change db_block_size ?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 08 Jul 1999 20:52:05 +0800
Message-ID: <37849EF5.6D69@yahoo.com>

Timpie wrote:
>
> Hi there,
>
> I recently installed an Oracle 8.0.5 DB and fortunately I discovered
> that the db_block_size is wrong before
> any data is loaded. Cou8ld you oracle freaks tell me the quickest way
> to change the db_block_size of my
> database without having to reinstall the whole bunch all over again. I
> know it can be done but it's been a while
> since I done something with oracle.
>
> Thanks
>
> Tim

The "quick and easy" way is

1. unload your database
2. recreate with new blocksize
3. reload data

The slow and painful and error-prone way is....the same as above...

Sorry ;-)
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Thu Jul 08 1999 - 07:52:05 CDT