Re: Locally managed tablespaces or...

On Tue, 18 Mar 2003 14:25:50 +0100, "dani" <drezustam#QUITAESTO#@airtel.net> wrote:

>Hi,
>I am planning a 9.2 database, and the locally managed tablespaces are new to
>me, 'cause I came from an 8.0.5.
>what is better: locally managed tablespaces or dictionary managed
>tablespaces??
>if so, is it good to set segment space management to auto?? works the
>bitmaps to manage free space fine?
>
>....
>
>thanks
>
>Daniel Rezusta
>
>

Hi Daniel,

As Niall pointed out, you should choose LMT's. In 9.2, you can even prevent the use of DMT's by creating a locally managed SYSTEM tablespace. Do that!

All that being said, LMT's have one drawback : MAXEXTENTS is disabled, so no segment residing in a LMT can be prevented from extending uncontrollably (at least not by MAXEXTENTS). That should be considered if you are migrating from DMT's which take advantage of MAXEXTENTS.

• Kenneth Koenraadt