Re: How to release space
From: joel garry <joel-garry_at_home.com>
Date: Mon, 18 Jan 2010 13:24:48 -0800 (PST)
Message-ID: <1410ed15-72dc-42e4-ba83-e08e88ca25a5_at_e16g2000yqc.googlegroups.com>
On Jan 18, 12:17 pm, "bob123" <bob..._at_gmail.com> wrote:
> 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
Date: Mon, 18 Jan 2010 13:24:48 -0800 (PST)
Message-ID: <1410ed15-72dc-42e4-ba83-e08e88ca25a5_at_e16g2000yqc.googlegroups.com>
On Jan 18, 12:17 pm, "bob123" <bob..._at_gmail.com> wrote:
> 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
Try doing it without reuse storage?
http://download.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_107a.htm#2067698
jg
-- _at_home.com is bogus. http://blog.thegentootux.com/2009/07/scotch-in-seattle.htmlReceived on Mon Jan 18 2010 - 15:24:48 CST