Hello,
I found a CLOB column in a DMS table that programmers were using to
store tiny strings (less than a couple kilobytes). Since CLOB columns
can only allocate entire kilobytes of space at best (when created with
the COMPACT qualifier), I know that this was wasting a lot of space in
the long tablespace. I added a VARCHAR(2048) column to that table so
it could hold those small strings instead, which allowed me to null
out the tiny CLOBs in the table by moving the text into the VARCHAR
column. Unfortunately, nothing I do seems to release the freed up CLOB
space to other tables. I've tried an inplace reorg of the table, as
well as an offline reorg, and the number of used pages in the
tablespace snapshot stays the same for the long tablespace.
Do I really have to drop and recreate the entire table in order to
reclaim the freed up CLOB space?
Fred