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!

Change db_block_size Oracle 10gR2

User374733Mar 3 2013 — edited Mar 4 2013
Platform: RHELinux4
Database: 10gR2

I had a database with 4k block size. Changed the db_block_size with steps:

Import
Drop database
Recreate database with 8k block size.
Create custom tablespace(s).
Export

The confuing thing is the result of below query as giving same result after block size change as was giving before the cloxk size change:

select a.OWNER,a.TABLE_NAME,a.NUM_ROWS,a.BLOCKS from dba_tables a
where a.OWNER='SCOTT';

OWNER TABLE_NAME NUM_ROWS BLOCKS
SCOTT T1 786432 3322


I was expecting the value of column "blocks" to reduce appx. half but its intact. Please suggest on this. Thanks.
This post has been answered by Jonathan Lewis on Mar 3 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 1 2013
Added on Mar 3 2013
6 comments
357 views