Re: Reclaim Tablespace after drop with purge options

From: Seth Miller <sethmiller.sm_at_gmail.com>
Date: Wed, 3 Sep 2014 12:17:18 -0500
Message-ID: <CAEueRAWWiE_VkPCjFxsc=u2YKcPFzKaGb8bN6jKiAfdPMF+M8Q_at_mail.gmail.com>

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:17:18 CEST

This message: [ Message body ]
Next message: David Barbour: "Re: expdp error - Not Even Sure Where to Look - Found It"
Previous message: Seth Miller: "Re: Woraround A: for performance problem on view joining several tables"
In reply to: Bala Krishna: "Reclaim Tablespace after drop with purge options"
Next in thread: Bala Krishna: "Re: Reclaim Tablespace after drop with purge options"
Reply: Bala Krishna: "Re: Reclaim Tablespace after drop with purge options"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message