Tuesday, January 18, 2011

How to Convert the Database Block Size

How to Convert the Database Block Size?

Database block size can only changed while creating the database, DB block size can't be changed after creating the database.


If you decided to change the database block size after database creation,The only possiblity is to export the full database and create a blank database with required DB block size and import the full database which was exported earlier.

High level steps are:

  • Take a Full export of the database you wish to change the db_block_size
  • Delete the database
  • Create a fresh database with the required db_block_size
  • Import the Full database which was exported.



  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer
    LinkedIn profile -
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at | +91 - 9581017828.