This content has been marked as final. Show 2 replies
You cannot change the block size after database creation except by re-creating the database.
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.