Re: Locally Managed vs Dictionary managed tablespaces

godmann wrote:
>
> Niall,
>
> So the only reason one uses LMT is to avoid fragmentation. Say I have
> third party tool to do online hot reorg, to reorg fragmented tablespace, will
> LMT offers any benefit?
>
> Allan W. Tham
> DBA
One obvious benefit is that you won't need to do any reorgs so you a) save resources
b) save on license costs for the reorg tool

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

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