Gurus,

I am running v9.2.0.1 on HP-UX on a (small=350GB) test datamart.

For testing purpose, I want to increase my db_block_size from 8K to 32K.

My plan is to generate an export (to DMP file) of my datamart schema,
change the value for db_block_size from 8K to 32K, rebuild my database and
import the data for my datamart schema.

Does this sounds like a reasonable approach? Are there "gotchas" that I
should be aware of?

Thanks in advance for your input.

kl.
Oracle LazyDBA home page