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!

Shrink tablespace after drop table

936749Oct 14 2014 — edited Oct 15 2014

Hi All,

I have dropped tables in a tablespace and would like to free up the space on the server.

What is the best way to shrink a tablespace to reflect the size after dropping objects?

I run Oracle 11g on Linux.

segment space management=automatic

extent management=local

I have tried to read through the following guide but I can't find the answer:

http://docs.oracle.com/cd/B28359_01/server.111/b28310/schema003.htm#ADMIN11601

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 12 2014

Added on Oct 14 2014

#general-database-discussions

3 comments

1,432 views