Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How does move tablespace use MORE space not less
Besides checking the tablespace storage allocation method and
parameters rebuilding a table can increase the size of the table due to
the re-establishing of the pctfree factor. If row updates consumed
most of the space reserved for updates then when these rows are copied
to a new block that block is going to have pctfree reserved. The
result could be that the total number of blocks necessary to hold the
data increases. You are most likely to see this when the pctfree is
set higher than the default.
HTH -- Mark D Powell -- Received on Tue Feb 07 2006 - 11:01:31 CST