ALTER TABLE SHRINK SPACE (Oracle 10gR2 Standard Edition)
Best regard, Guys.
Please request your support, motivated that I’m trying to purge the HWM in a group of Tables of an Oracle Database (10gR2 Standard Edition) and observing a strange behavior.
The procedure that I'm applying is the following:
alter table owner.table_name enable row movement;
alter table owner.table_name shrink space;
alter table owner.table_name disable row movement';
Refresh Statistics of the Tables.
After refreshing the statistics I use the following query to validate that it effectively recovered the space occupied by the HWM, however, I notice that the space does not recover.
select /*+ rule */ a.owner, a.segment_name, a.segment_type, round(a.bytes/1024/1024,0) MBS,