It didn't *sound* like the sort of thing that you'd say. Cheers
--
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
******************************************
"Jim Kennedy" <kennedy-down_with_spammers_at_attbi.com> wrote in message
news:O64Q9.168404$qF3.12270_at_sccrnsc04...
> Yes. it was too early or late; can't remember which. You are correct
> mistyped.
> Jim
> "Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message
> news:3e109d7a$0$231$cc9e4d1f_at_news.dial.pipex.com...
> > "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
> > ******************************************
> >
> >
>
>
Received on Tue Dec 31 2002 - 09:58:08 CST
