-
shrinking a partitioned table (pctfree)
I am looking for the best way to reclaim unused space for my paritioned table.
My predessor setup a table with a pctfree of 40,which is a huge waste of
space, since all of the data that goes into this table is never updated.
Therefore, I am thinking I would like to set pctfree 0 to see how much
space I can re-gain.
When I usually re-claim space in a paritioned table I do the following:
alter table move partition compress
storage( initial 1k next 1k pctincrease 0 minextents 1 );
Can somebody please provide me with the high level steps (correct
syntax) to decrease my pctfree from 40 to 0 on a partitioned table.
Would it be this:
alter table pctfree 0;
Do I need a move command within the same TS?
rebuild global indexes?
Thanks
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
|
|