Hi Tom,

I have a very simple table:

create table foo (
num integer,
bar clob);

The initial size of the LOB segment (taken from the user_segments table) was 81,920 bytes.

I inserted three rows into this table, to get the bytes allocated to exceed the original extent; I ended up at 327,680 bytes. I then deleted the three rows, but the space occupied by the LOB segment did not change.

After some reading I came upon this command:

alter table foo modify lob (bar) (deallocate unused);

Which got me down to 286,720 bytes. An improvement, but still a lot of wasted space.

So the question is, how can I reclaim this unused space?

thanks,

janine