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 alter tablespace to use different Block Size?

mohitanchliaJun 4 2009 — edited Jun 5 2009

Oracle 11.0.1.7:

Is there a way to alter block size of a tablespace from 32k to 8k? I have whole bunch of schema in the database so I want to change the block size without having to drop all the tables. Dropping contents is fine because it's a dev. db

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 3 2009

Added on Jun 4 2009

#general-database-discussions

7 comments

972 views