RE: Changing block size

Thank you all for replies.
I will take a look at it.

Eugene Pipko
P  Please consider the environment before printing this e-mail.

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Bort, Guillermo
Sent: Wednesday, December 03, 2008 9:41 AM
To: exriscer@xxxxxxxxx; Eugene Pipko
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: Changing block size

Yep, create a new database with db_block_size in 8k and export/import.

Also, I'd suggest 10.2.0.4 on SunOS 5.10 or RHEL4u6, but I think that's  not 
what you asked.

Guillermo Alan Bort
DBA / DBA Main Team

EDS, an HP company
ITO
Arias 1851
Ciudad Autonoma de Buenos Aires (C1429DXC)
Argentina

Tel: +54 11 4704-3132
E-mail: guillermo.bort@xxxxxxx<mailto:name.name@xxxxxxx>

We deliver on our commitments
so you can deliver on yours.

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of LS Cheng
Sent: Wednesday, December 03, 2008 3:27 PM
To: eugene.pipko@xxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Changing block size

I am afraid export and import is your only choice


--
LSC
On Wed, Dec 3, 2008 at 6:14 PM, Eugene Pipko 
<eugene.pipko@xxxxxxxxxxxx<mailto:eugene.pipko@xxxxxxxxxxxx>> wrote:

Hi all,

I am running Oracle 8.1.7.4<http://8.1.7.4>. on Win2000 Adv Server.

The parameter db_block_size is set to 4K. I'd like to change it to 8K.

What are my options?



Eugene Pipko

P  Please consider the environment before printing this e-mail.

Other related posts: