Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Space is not released from tablespaces even after purging recycbin

MahipalJun 19 2009 — edited Jun 19 2009

Hi,

I had 168GB of space occupied by recyclebin objects (BIN$...) when i queried on dba_segments, after purging the recyclebin it is showing 0.

But i didn't find any difference in the free space dba_free_space in tablespaces before and after purging.

Is it the thing that even after purging recycbin, it is not released the space for respective Tablespaces?

Also wanted to know how to release the space.

Thanks,
Mahi

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 17 2009

Added on Jun 19 2009

#general-database-discussions

12 comments

2,100 views