Change db_block_size Oracle 10gR2
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.