Friday, September 26, 2008

Oracle: How to shrink table

How to shrink oracle tables


Alter table table_name enable row movement;
Alter table table_name shrink space;

To find out size of any table

Select segment_name,bytes/1024/1024 size_in_MB
from user_segments
where segment_name = 'your_table_name'

No comments:

Post a Comment