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.


RELATED POSTS


2 comments:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete