Re: locally managed tablespace & dictionary managed tablespace

"Jim Kennedy" <kennedy-down_with_spammers_at_attbi.com> wrote in message news:9mPP9.160621$qF3.11566_at_sccrnsc04...
> Don't use locally managed tablespaces.
> Jim

Is locally a typo for dictionary in the above? I generally don't like absolute positions very much but I can see no reason whatsoever to retain DMT's.

LMT's have the two following key advantages

Massively reduced impact on the data dictionary. Elimination of extent fragmentation entirely (if using the uniform clause).

Now admittedly you might over allocate disk space for an LMT, in comparison to a DMT, but that impact shouldn't be huge and as it avoids previously necessary downtime the cost is pretty well insignificant.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************