By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,973 Members | 1,532 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,973 IT Pros & Developers. It's quick & easy.

Reclaiming LOB space from deleted CLOBs in V8.1.5?

P: n/a

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?

Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.