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 8.1.7.4 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.

Dig Deeper on Oracle database administration

SearchDataManagement
SearchBusinessAnalytics
SearchSAP
SearchSQLServer
TheServerSide.com
SearchDataCenter
SearchContentManagement
SearchHRSoftware
Close