Re: reclaiming space from recycle bin

On Tue, Dec 8, 2009 at 12:11 PM, <Sharon.Kovac@xxxxxxxxxxxxxxx> wrote:

>
>  However, when I look at the space, I don't see that I got 2GB back.


Where are you looking?

If at the file level, the space will not be reclaimed, as Oracle isn't
giving space back to the OS.

The reclaimed space will be extents that are again available for use.

Reclaimed space will be visible via either dba_extents or dba_segments.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com

Other related posts: