Reclaim Tablespace after drop with purge options

From: Bala Krishna <krishna000_at_gmail.com>
Date: Wed, 3 Sep 2014 13:05:12 -0400
Message-ID: <CAG+FZahZ-D98pZ3p1nMNWDysnDaEeFhCpY22oigjLRCtiku9iQ_at_mail.gmail.com>

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:05:12 CEST

This message: [ Message body ]
Next message: Seth Miller: "Re: Woraround A: for performance problem on view joining several tables"
Previous message: Freek D'Hooge: "Re: expdp error - Not Even Sure Where to Look"
Next in thread: Seth Miller: "Re: Reclaim Tablespace after drop with purge options"
Reply: Seth Miller: "Re: Reclaim Tablespace after drop with purge options"
Reply: Hans Forbrich: "Re: Reclaim Tablespace after drop with purge options"
Maybe 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