Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

can we modify db_block_size?

755678Sep 28 2010 — edited Sep 28 2010
Can we modify db_block_size parameter?
I have a 9i database and I am migrating few of the schemas of this 9.2.0.8 database to a new 11g (11.1.0.7) database.
The current 9i database has a db_block_size parameter of 16384, but the 11g database is 8192.
Can we change the value of this parameter from 8192 to 16384 in 11g? Please let me know!

Thanks!
This post has been answered by CKPT on Sep 28 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 26 2010
Added on Sep 28 2010
7 comments
7,090 views