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'
Labels:

2 comments:

  1. andrea chiuApril 16, 2015 at 1:03 AM

    Health is one of the many aspect in our life that we should take good care because if we are sick , we became useless and unimportant. We loose hope and everything became stagnant. Visit my site for more information. Thanks.

    triciajoy.com

    ReplyDelete
  2. moshrabbi121June 19, 2018 at 9:33 PM

    This web page is mostly a walk-through for all the information you needed about this and didn’t know who to ask. Glimpse here, and you’ll positively uncover it. online casino slots

    ReplyDelete

Subscribe to: Post Comments (Atom)