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> wrote: Hi all, I am running Oracle 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.