impdp one user only
From: J. Dex <cemail_219_at_hotmail.com>
Date: Thu, 14 Feb 2008 14:58:06 -0500
Message-ID: <BAY140-W27C41F982C0D96590AD9EA5250@phx.gbl>
Helping your favorite cause is as easy as instant messaging. You IM, we give. http://im.live.com/Messenger/IM/Home/?source=text_hotmail_join
Date: Thu, 14 Feb 2008 14:58:06 -0500
Message-ID: <BAY140-W27C41F982C0D96590AD9EA5250@phx.gbl>
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. http://im.live.com/Messenger/IM/Home/?source=text_hotmail_join
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 14 2008 - 13:58:06 CST