Skip to Main Content

Database Software

deallocate unused space

806692Nov 19 2010 — edited Dec 28 2010
Hi Folks,

I would like to know the difference between these 2 ways of deallocating the unused space.
Can you please provide me the details?

way1:
alter table table_name deallocate unused;

way2:
alter table table_name enable row movement;
alter table table_name shrink space compact;
alter table table_name shrink space;
alter table table_name disable row movement;

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 25 2011
Added on Nov 19 2010
2 comments
3,356 views