Re: Lob Segment Space Reclaim

Hi Dicky,

I think your best option may be to implement PARITIONING, if of course it's possible for you to do so. This will benefit you in at least two ways

1). Fast removal of records
2). Reclaim space

Good Luck,

Greg.

"dicky" <ccmdicky_at_netvigator.com> wrote in message news:<aq5u0v$b5b40_at_imsp212.netvigator.com>...
> Hi there,
> I got a touch question recently and hope you give me a hint to solve it. I
> have a 5G table with a lob column. Due to space limit, I have to achive and
> purge the records of this table and free more space for incoming records.
> More than half of the records in this table therefore had been deleted;
> however the outcome was disppointed -- only about 200M is released.
>
> After investigated, the reason to this figure is the lob segment size of
> this table remains intact (>4G). Is there any way to reclaim/unallocate
> space from this huge lob segment, just like alter table ... unallocate ..?
>
> Any input would be appreciated. Thanks in advanced!
>
> Dicky
Received on Tue Nov 05 2002 - 22:46:26 CST