Increase block Size

[richardtsa]

Hi
Can anybody tell me if it is possible to increase the database block size without recreating the database and if so can please tell me how to do it.


Any help will be appreciated


Thanks

 

[bjoern6689]

Depend on the version. In 8.1.7 it's not possible

 

[rcurva]

Starting Oracle 9i, you can have multiple db_block_size on your tablespaces. But lower versions requires a rebuild of the database.
Robbie

"The rule is, not to besiege walled cities if it can possibly be avoided" -- Art of War

 

[richardtsa]

Thanks for the help, I am using 8.1.7