RE: CLOBs storage vs Varchar storage

2001-08-13 Thread Jack C. Applewhite
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

Re: CLOBs storage vs Varchar storage

2001-08-13 Thread Jonathan Gennick
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