DMT and LMT

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Thu, 20 Mar 2003 14:07:55 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA70374276C@lnewton.leeds.lfs.co.uk>

Hi Hanne,

you wrote :

>> 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.. I don't think the fact that you have LMT while the data was exported from a DMT is the cause of the failure. I have many customers running DMT or LMT and some running both, who regularly send us export files. I can import them quite happily into a 9i R2 LMT database.

What errors are being thrown by import ?

>> 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.

By 'starange databases' you do mean 'from other Oracle databases' don't you ?

>> 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?

LMT can handle imports from DMT or LMT or both, it makes no difference.

Now, while typing the above, I had a thought. If your 9i database is created with LMT SYSTEM tablespace, then you will not be allowed to create any DMTs. I wonder if you are doing FULL exports/imports and having the import create the tablespaces and because the sending database is DMT, the creation is failing because DMTs are not allowed on a database with an LMT SYSTEM tablespace ?

If this is the case then I suggest the following *may* help :

	pre-create your tablespaces as LMT
	pre-create 
	import users not the entire database
	ask your users/customers to send you user exports rather than

full exports.

So if your user sends you a FULL export file, simply import the user you want by specifying the fromuser and touser parameters.

>> English is not my native tounge

Nor mine - I'm Scottish :o)
Your English is *far* better than my Norwegian !

Cheers,
Norman.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------

Received on Thu Mar 20 2003 - 08:07:55 CST