Re: change db_block_size ?

You do not need to re-install the software, how ever you will need to do this;

export the data that you need
shutdown the database
take a full cold os backup of the database remove the database
build a new database with the correct block size import your data

Freaks ???

--
The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation.

Daniel
Oracle UK

Connor McDonald <connor_mcdonald_at_yahoo.com> wrote in message news:37849EF5.6D69_at_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
>
> a. unload your database
> b. recreate with new blocksize
> c. 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 Fri Jul 09 1999 - 07:31:48 CDT