Re: LMT is preferred than DMT.. but then

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Wed, 24 Mar 2004 16:08:58 +1100
Message-ID: <406117eb$0$31906$afc38c87@news.optusnet.com.au>

"yls177" <yls177_at_hotmail.com> wrote in message news:c06e4d68.0403231921.171231e6_at_posting.google.com...
> i am surprised... i am on oracle 9i with datafiles of over 30gbs
> each.. and my tablespace management is dictionary....
>
> will i have lots of problem if i switched them all over to LMT during
> the process

If everything is working fine, why switch at all?

*IS* everything fine?

You can't "switch them over" to LMT. You can use a package supplied by Oracle if you want a half-assed botch job, for sure. But otherwise, conversion to LMT means creating new tablespaces which are LMT and then moving tables, indexes and other segments over to the new tablespaces. That's a lot of I/O. Will that pose you a problem? I can't answer that... I know nothing about your maintenance windows or your service standards. It's an issue that has to be faced, though.

Fortunately, you could migrate to LMT little by little, table by table. There's no law that states everything must become LMT at the same time.

Regards
HJR Received on Tue Mar 23 2004 - 23:08:58 CST