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!

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,777 views