Pages

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


Posted by Naresh Miryala

2 comments:

  1. Ankit AggarwalOctober 1, 2015 at 12:15 PM

    superb

    ReplyDelete
  2. UnknownAugust 1, 2016 at 10:38 AM

    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

Subscribe to: Post Comments (Atom)