Re: locally managed tablespace & dictionary managed tablespace

Hi Bert,
Thanks.
I have yours and Howard's respond all suggest to use LMT. So that's what I'm gonna do, if I ever get a job as an Oracle DBA. :P

Regards,
Andi

"Bert Bear" <bertbear_at_NOSPAMbertbear.net> wrote in message news:4nRP9.2529$da3.1526135006_at_newssvr11.news.prodigy.com...
> Andi,
>
> IMHO, LMT are the only way to go. This opinion is from 23 years of being
a
> operating system developer (e.g. file systems, IPC, GUI, schedulers,
> dispatchers, memory management, internal trace, abend processing
> backup/recovery applications, etc.) on three different operating systems
> (IBM VM, Cray UNICOS, and IBM OS/2). The design of LMT is much better
than
> DMT (and the implementation seems to be better).
>
> Bertram Moshier
> Oracle Certified Professional 8i and 9i DBA
>
> http://www.bmoshier.net/bertram
>
>
> "andi" <andi_at_a.com> wrote in message
> news:auodnb$7d5$1_at_mawar.singnet.com.sg...
> > Hi,
> > newbie question.
> > I've read some books which mentioned about advantages of locally-managed
> > tablespace over dictionary-managed tablespace.
> > My question is, are there advantages of dictionary-managed tablespace
over
> > locally-managed tablespace ?
> > or when should we use dictionary-managed tablespace instead of
> > locally-managed tablespace ?
> >
> > TIA,
> > Andi
> >
> >
> >
>
>
Received on Mon Dec 30 2002 - 01:11:33 CST