Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> DMT and LMT

DMT and LMT

From: Hanne Iren Midttun <hannem_at_tihlde.org>
Date: Thu, 20 Mar 2003 14:39:25 +0100
Message-ID: <Pine.LNX.4.21.0303201412190.2978-100000@colargol.tihlde.org>


Hi,
I have read some of the documentation about this, but I not really sure what the best sollution for our company is. I would be glad to get advices from you.

We are running 8.1.7 on AIX. We will upgrade to 9i in late 2003 or early 2004. Today all our production databases are using DMT, but we are planing to migrate to LMT

So far so good, and now what causes my headace :-) We are getting our data from external sources (more than one). And offcource, we have no control over what versions they have or if they are using DMF of LMF. The date is handle to us by export files. Right now we have an 9i release 2 export with DMT. We have created an 9i release 2 test database to import the data, but it failes because we have createt our test database with LMT..

OK - I can fix this, but how to make an enviroment witch can handle the fact that we can get our data from really strange databases? This is the challange.

I was thinking the best sollution was to have a 9i relase 2 database in our test enviroment (since Oracle is backward compatible this database would handle all the exp files we get - no matter the version they are exported from?) with a DMT system tablespace (then we could handle both DMT and LMT?) Some comment?

regards Hanne

--
Hanne Midttun
http://www.tihlde.org/~hannem

English is not my native tounge
Received on Thu Mar 20 2003 - 07:39:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US