RE: Reclaim Tablespace after drop with purge options

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Wed, 3 Sep 2014 14:46:35 -0400
Message-ID: <0cac01cfc7a7$63e8f0f0$2bbad2d0$_at_rsiz.com>

Create and drop a wee little table in one of those tablespaces and check again.  

By the way, HOW are you checking for free space?  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bala Krishna Sent: Wednesday, September 03, 2014 1:49 PM To: Seth Miller
Cc: oracle-l_at_freelists.org
Subject: Re: Reclaim Tablespace after drop with purge options  

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 - 20:46:35 CEST