Re: Reclaim Tablespace after drop with purge options

Its not compressed.

Regards
Bala

On Wed, Sep 3, 2014 at 1:17 PM, Seth Miller <sethmiller.sm_at_gmail.com> wrote:

> Bala,
>
> Were these compressed tables? Is it possible that they were only occupying
> 3GB of physical space?
>
> Seth Miller
>
>
> On Wed, Sep 3, 2014 at 12:05 PM, Bala Krishna <krishna000_at_gmail.com>
> wrote:
>
>> Hi All,
>>
>> Our DB oracle 11gr2 with segment space mangement manual for all the
>> tablespaces that we have for some other reasons so that i dont want to go
>> deep in that.
>>
>> But we have dropped some 1TB tables with purge option directly but the
>> space is not reclaimed at all not sure why if i check the free space of
>> tablespace it just freed only 3GB. Any ideas appreciated.
>>
>> Regards
>> Bala
>>
>
>

--
http://www.freelists.org/webpage/oracle-l