Prev: Oracle 11g OCA/OCP Exams
Next: Is AskTom Down...Again?
From: bob123 on 18 Jan 2010 15:17
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



From: joel garry on 18 Jan 2010 16:24
On Jan 18, 12:17 pm, "bob123" <bob...(a)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
--
@home.com is bogus.
http://blog.thegentootux.com/2009/07/scotch-in-seattle.html
From: Mladen Gogala on 18 Jan 2010 17:40
On Mon, 18 Jan 2010 21:17:10 +0100, bob123 wrote:

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

TRUNCATE TABLE DROP STORAGE;



--
http://mgogala.byethost5.com
 | 
Pages: 1
Prev: Oracle 11g OCA/OCP Exams
Next: Is AskTom Down...Again?