Skip to Main Content

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!

release space after drop

User_U9EN2Jan 16 2020 — edited Jan 16 2020

Hi All,

Oracle 11gR2.

I have dropped 20% of partitioned table partitions from my database.

alter table <tablename>  drop partition <partition-name> UPDATE INDEXES;

Then to release OS space;

ALTER TABLE <tablename> ENABLE ROW MOVEMENT;

ALTER TABLE <tablename> SHRINK SPACE CASCADE;

But when I check the database size its still same..

The shrink should release space OR do I need to resize the datafiles...

Thanks

Comments
Post Details
Added on Jan 16 2020
4 comments
1,460 views