How to release space

From: bob123 <bob123_at_gmail.com>
Date: Mon, 18 Jan 2010 21:17:10 +0100
Message-ID: <4b54c1c3$0$12223$426a74cc_at_news.free.fr>



Hi

I have a big table with 2 clob columns
I have to truncate this table

I did:
> truncate table blabla reuse storage;

after I did:
> alter table blabla deallocate unused;

but it doesn't free space allocated for the LOBSEGMENT's how can I get the released space ?

Thanks in advance
9.2.0.6 Received on Mon Jan 18 2010 - 14:17:10 CST

Original text of this message