> -----Original Message-----
> From: Miller, Jay [mailto:[EMAIL PROTECTED]]
>
> My understanding was that the main reason to keep the number
> of extents down
> was in case you needed to drop or truncate the table it would
> take Oracle a
> long time to clean up the fet$ table.
> I think, and I emphasize that I am not certain of this, that
> this is no
> longer a problem with locally managed tablespaces.
> I'm sure someone will correct me if I'm wrong...
As usual, Steve Adams has some sage advice on the subject. Check out his article "Planning Extents"
http://www.ixora.com.au (click on Tips then on Planning Extents)
in which he mentions that there are reasons for keeping the number of extents down even in a locally managed tablespace.
