Help with Exporting/Importing

From: Adrian Harrison <adrianh_at_globalnet.co.uk>
Date: Wed, 25 Aug 1999 09:23:31 GMT
Message-ID: <37c3b470.55428371@news.globalnet.co.uk>

Using Oracle 7.3.4

I have a user "NLS" in one Oracle database that I want to export all objects owned by them and only them to another Oracle database

All I want to do is to export to a file called NLS.DMP then import this file on the other system. I would like the user NLS & Tablespaces created at the same time if this is possible with exactly the same permissions etc...

I've tried messing with EXP73 & IMP73 utilities but there seems to be a serious lack of documentation (or I can't find it). I worried about messing the whole database up!

Can anyone please give me some sample lines as to how to achieve this?

Thanks in advance!

Adrian Harrison Received on Wed Aug 25 1999 - 04:23:31 CDT