Manage Learn to apply best practices and optimize your operations.

How to rebuild a database to change Oracle block size

Oracle expert Brian Peasland explains how to rebuild an Oracle database in order to change the block size from 4K to 8K.

I have Oracle with a 4K block size. I'd like to set it to an 8K block size. What are my options? Can I use export/import to do this?
The only way to change the block size is to rebuild the database. The export/import utilities are unaware of the block size, so they are used in this operation. First, take a full export of your database. Then delete the old database. Next, recreate the database with the 8K block size. Lastly, perform a full import from the dump file you created. On import, the data will go into the new, 8K block size database.

As with any operation like this, it is a good idea to verify that you have a good backup of your database to revert...

back to, should something go wrong. Don't let the export dump file be your only backup. If the database is not too large, shut it down and take a cold backup of the database before removing it from your system.

This was last published in December 2008

Dig Deeper on Oracle database administration



Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.