Re: migrating from LMT to DMT in oracle and downtime

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: 25 Jul 2005 01:11:43 -0700
Message-ID: <1122279103.193992.13100@g47g2000cwa.googlegroups.com>

chao_ping wrote:
> Hi, Noons,
> We are planning to do this convertion on a big production box,
> because we suffered from ST enqueue.
> I don't see any known issue in metalink, can you point some known
> issue with this package?
>
>

Do a search on LMT in bug db and read the results. Most of the public bugs are with those who used the package.

I never used it and don't plan to. It doesn't even do a good job of converting to a proper LMT: Jonathan showed a while ago some of the problems it has.
My advice is: bite the bullet and do a refresh. It doesn't really take

that much longer than a conversion and you end up with something that works the way it was designed to.

And please, do NOT leave the system tablespace in DMT while the rest is in LMT: it's really not a good idea. Although some claim that LMT and system tablespace are bad: invariably, these are the ones who used conversion instead of refresh... Received on Mon Jul 25 2005 - 03:11:43 CDT