This content has been marked as final. Show 2 replies
Beginning in 9i you can have TABLESPACES with different block sizes within the same database instance. Take a look at the db_nk_cache_size parameter.
Also look at the blocksize clause of the create tablespace statement.
As Laurent said, you can't change the block size of your database.