Re: Reclaim Tablespace after drop with purge options
- From: Bala Krishna <krishna000@xxxxxxxxx>
- To: Seth Miller <sethmiller.sm@xxxxxxxxx>
- Date: Wed, 3 Sep 2014 13:49:20 -0400
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@xxxxxxxxx> wrote:
> Bala,
>
> We're there LOB columns in any of those tables?
>
> Seth Miller
>
>
> On Wednesday, September 3, 2014, Bala Krishna <krishna000@xxxxxxxxx>
> wrote:
>
>> Miller,
>>
>> Its not compressed.
>>
>> Regards
>> Bala
>>
>>
>> On Wed, Sep 3, 2014 at 1:17 PM, Seth Miller <sethmiller.sm@xxxxxxxxx>
>> 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@xxxxxxxxx>
>>> 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
>>>>
>>>
>>>
>>
Other related posts:
