Re: Local managed tablespaces

Frank Black wrote:
>
> All,
>
> does anyone have experience with Local Managed Tablespaces. If yes, did you
> use the uniform or autoallocate
> option? What are the reasons to choose for Autoallocate or the Uniform
> option? Why use Uniform when Oracle
> can handle the exent allocation by itself?
>
> thank in advance,
>
> Hink Wiersema

I prefer uniform size because
a) you can choose your own size
b) fragmentation is zero

I can't think of a reason why every tablespace (except system) should not be locally managed for any new database.

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"