Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

oracle clob size

user558363May 12 2008 — edited May 12 2008
I am using clobs to store text messages which are typically between 1 and 10k in size. Am I correct in understanding that each clob takes a minimum of one database block of storage (8kb in my case)? (i.e. chunksize is dependent on db block size). If the clobs are stored inline instead of in a separate table, does this also apply?

Thanks,

Werner
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 9 2008
Added on May 12 2008
2 comments
1,150 views