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!

How to shrink tablespace?

846231Sep 12 2011 — edited Mar 26 2013

Hi all,

Oracle10g and 11g
Windows 2003 server

I have lots of big tables in my HR schema which are candidate for backup and removal.
If I drop this large tables, how can I reclaim the space from OS side? It resides at my c:\ which is almost 100% full :(

Is there an "alter database shrink tablespace"?

Thanks.

This post has been answered by KrishnaAgnihotri on Sep 12 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 23 2013

Added on Sep 12 2011

#general-database-discussions

12 comments

50,820 views