RE: impdp one user only

  • From: Josh Collier <Josh.Collier@xxxxxxxxxxxx>
  • To: "cemail_219@xxxxxxxxxxx" <cemail_219@xxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 14 Feb 2008 14:13:47 -0800

uses schemas=

this should specify the user you want. then use remap_schema=fromuser:touser

josh c.

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of J. Dex
Sent: Thursday, February 14, 2008 11:58 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: impdp one user only

I want to do an import into a user's schema using impdp from a full export done 
with expdp.  I am confused by the syntax though.  I used this but then it seems 
to import the entire database.  What do I need to change or what am I missing?

Impdp system/<pwd>@<SID> dumpfile=<export_name>.dmp directory=my_dir 
logfile=<logfile_name.log>  encryption_password=<encrypt_pwd> 
REMAP_SCHEMA=username.username buffer=262144000

Helping your favorite cause is as easy as instant messaging. You IM, we give. 
Learn more.<>

Other related posts: