Re: Reclaim Tablespace after drop with purge options

From: Bala Krishna <krishna000_at_gmail.com>
Date: Wed, 3 Sep 2014 13:49:20 -0400
Message-ID: <CAG+FZaiBPLE9bSwJ1fwmY7-F=nNfEJmb_hAt+LHqyUTsSrMr8w_at_mail.gmail.com>

It doesn't have any un-structured data types at all and recycle bin is already empty.

Regards
Bala

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

> Bala,
>
> We're there LOB columns in any of those tables?
>
> Seth Miller
>
>
> On Wednesday, September 3, 2014, Bala Krishna <krishna000_at_gmail.com>
> wrote:
>
>> Miller,
>>
>> 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

Received on Wed Sep 03 2014 - 19:49:20 CEST