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!

shrinking locally managed tablespace

user5913719Jul 21 2010 — edited Jul 21 2010

Hi,

I have an Oracle 10gR2 database with locally managed tablespaces. In the tablespaces I deleted a lot of tables by using drop table ... purge. As expected the tables are deleted but the size of the tablespace is unchanged.

Is there a simple way to shrink the size of the tablespace (respectively the datafiles) ?

Thank you.

Best regards,
Alex

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 18 2010

Added on Jul 21 2010

#general-database-discussions

8 comments

1,536 views