I thought so as you can't change the block any other way on the front
page of the wizard as it is grayed out.

So that means you are going for one of the predefined templates as well,
I suspect that these are actually going to copy a pre-built database
image with a fixed block size so it will get so far and then fail.

I tried it a few times as I thought it would be a quick way to create a
database but in the end I used a set of scripts to create the database I
wanted, even though it took ages to run all the script it got me the
database block size I wanted. Using scripts also means it is easy to
reuse/modify these later as I need to create new databases fairly
regularly.

You should be able to go the custom route as well although I haven't
tried it for a long time.

Regards

Mike

-----Original Message-----
From: Satish Radhakrishnan
[mailto:oracledba-ezmlmshield-x67952615.[Email address protected]
Sent: 30 September 2005 15:04
To: LazyDBA Discussion
Subject: Re: Db_Block_Size(Urgent)

I am using DBCA & in the Parameter File I'am Changing it .

Regards
Satish
----- Original Message -----
From: Satish Radhakrishnan
To: LazyDBA
Sent: Friday, September 30, 2005 7:08 PM
Subject: Db_Block_Size(Urgent)


Hi Gurus,

Iam creating a database in Oracle 9i Release(9.0.1.0.1) . In this
Block Size(default) is of 4 Mb. So when i use this the database is
created succesfully.
But when I Change the db_block_size = 8 Mb . . It fails in creating
a database.
Why is this so?
Thank you in Advance

Regards
Satish R



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page