|
-
 Originally Posted by BeefStu
When I usually re-claim space in a paritioned table I do the following:
alter table table name move partition partition name compress
storage( initial 1k next 1k pctincrease 0 minextents 1 )
1K initial and next?
Usually, partitioned tables are - by design - large tables; having extent size of 1K would create zillions of extents.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote