Originally posted by grjohnson
If inserted larger than db_block_size, then yes. The idea is to have a block size large enough to accomidate your rows. Remember, storage and performance go hand in hand.
Thanks for the reply..

But in case of large and wide (many columns especially with with varchar2) tables it is difficult to control row length below db_block_size.

I have few tables which stores medicine procedures and diagnosis, and it difficult to chop table in two different tables.
and these tables row length is more than db_block_size..

Any suggestion in this scenario..

Thanks

Sameer