Good catch Justin! I think the max block size you can go is about 32K. I am not sure if we can go for 64K size but my present understanding say 32K is the largest block size we can have.

Gurmohan
www.freemath.info - The ultimate tool in learning and teaching math skills.



-----Original Message-----
From: Justin Cave (DDBC)
[mailto:oracledba-ezmlmshield-x1580249.[Email address protected]
Sent: Friday, September 30, 2005 11:51 AM
To: LazyDBA Discussion
Subject: RE: Db_Block_Size(Urgent)


Just for sanity, do you really mean that you're trying to use an 8 kb
block size rather than a 4 kb block size? Neither 4 MB nor 8 MB are
valid block sizes for a database.

Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

-----Original Message-----
From: Satish Radhakrishnan
[mailto:oracledba-ezmlmshield-x76088026.[Email address protected]
Sent: Friday, September 30, 2005 9:39 AM
To: LazyDBA Discussion
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



--------
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