Database Administration (MOSC)

MOSC Banner

ALTER TABLE SHRINK SPACE (Oracle 10gR2 Standard Edition)

edited June 2017 in Database Administration (MOSC) 4 comments

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,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center