Rick,
If the CLOB is <4KB and stored inline with the table, then it takes up only
as much space as it needs - much like a VarChar2. If the CLOB is stored
out-of-line in a LOB segment, it takes at least one, possibly many more,
Oracle DB Blocks, depending on your specification of "Chunk" in the C
Monday, August 13, 2001, 1:50:28 PM, Clark wrote:
>> CLOBs vs VARCHAR. If a varchar datatype is not completely used it will
>> not allocate storage for what is was defined.
>> Does a CLOB data type use entire storage if not completely used?
No. If you think about it long enough, you'll realiz