Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Free Space within Table or Index
Tim Witort wrote:
> maxextents of 50 and only 10 are allocated, then you
> were off. If you expect NO GROWTH after your inital
> loading of data, then try to size it such that it uses
> the same number of extents as maxextents.
Maybe I misunderstood what you said but if the table expects no growth, the initial extent should be large enough to fit all the data. Maybe you meant minextents=maxextents=1?
Dave Received on Thu Aug 14 1997 - 00:00:00 CDT