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