RE: impdp one user only

From: Josh Collier <Josh.Collier_at_banfield.net>
Date: Thu, 14 Feb 2008 14:13:47 -0800
Message-ID: <578806DDE66A3A45916740EB73C6982ADB05840623@M1EXCHANGE01.mmi.local>


uses schemas=

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

josh c.



From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of J. Dex Sent: Thursday, February 14, 2008 11:58 AM To: oracle-l_at_freelists.org
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.<http://im.live.com/Messenger/IM/Home/?source=text_hotmail_join>
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 14 2008 - 16:13:47 CST

Original text of this message