"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<406117eb$0$31906$afc38c87_at_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
isnt it evident enough that LMT is going to last , and better
performance?
also, conversion to LMT has to depend on the types of applications
running on oracle?
Received on Wed Mar 24 2004 - 23:07:47 CST
