Re: locally managed tablespace & dictionary managed tablespace

From: Bert Bear <bertbear_at_NOSPAMbertbear.net>
Date: Mon, 30 Dec 2002 06:05:52 GMT
Message-ID: <4nRP9.2529$da3.1526135006@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 - 00:05:52 CST