Re: Help with Exporting/Importing

From: Luis Campos <lcampos_at_cpcis.pt>
Date: Wed, 25 Aug 1999 12:46:59 +0100
Message-ID: <7q0l02$19$1@duke.telepac.pt>

"Lack of Documentation" can also be "Lack of Will to Find It"... Anyway...Two things: don't name you users or objects after Oracle Reserved words. Second: If you want to pick a user from one DB and put it in another DB you have to follow these tasks:

1) run on the OS console: exp user/password FILE=user.dmp
2) create a user on the target DB (say called user_target)
3) Give this user_target the same permissions the user from the source DB

had
4) run the following command: imp user_target/password FILE=user.dmp FULL=Y if you try to do it on top of a user_target and some of the objects might already exist, you might consider adding the argument IGNORE=Y.

Luis Campos.

Adrian Harrison wrote in message <37c3b470.55428371_at_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 - 06:46:59 CDT