Pavan DBA's Blog

The DBA Knowledge Store

Posts Tagged ‘How to create database with different block size than 8kb with DBCA?’

How to create database with different block size than 8kb with DBCA?

Posted by Pavan DBA on September 28, 2012


Just want to share some information on how to create a database with block size other than 8KB with DBCA. Usually when we try to create a database with DBCA, by default it will take block size as 8KB and it will not give us the option of changing it as shown below in the screenshot

 

so incase if we want to create with a different blocksize, what we need to do? solution is very simple, in the type of database screen (which is usually 3rd screen in DBCA) we need to select “CUSTOM DATABASE” option. Screenshot is below

 

After selecting “custom database” as shown above, if you proceed for further steps, then you will be seeing oracle will gives you the option to change the block size. screenshot below…

 

So, friends use this if at all you want to create a different block size database

HAPPY LEARNING !!!

Posted in Admin | Tagged: , , | 8 Comments »

 
%d bloggers like this: