To continue reading for free, register below or login
To read more you must become a member of SearchOracle.com
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.
|
