Quest
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment