SQL & PL/SQL

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to change existing database block size in all tablespaces

569125Mar 29 2007 — edited Mar 29 2007

Hi,

Need Help to change block size for my existing database which is in 8kb of block size.

I have read that we can only change block size during database creation, but i want to change it after database installation.
because for some reason i dont want to change the database installation script.

Can any one list the steps to change database block size for all existing table space (except system, temp ).

want to change it to 32kb.

Thank you for you time.

-Rushang Kansara

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 26 2007

Added on Mar 29 2007

9 comments

1,622 views