Hi "impdp help=y" on the command prompt is usually enough for me to find out what to do when stuck. Jack On 15/02/2008, Bradd Piontek <piontekdd@xxxxxxxxx> wrote: > > All that is going to accomplish is remapping a schema. REMAP_SCHEMA is for > takig sa USER1's opbjects and importing them into USER2 (fromuser,touser in > the old imp world). > > > At a minimum you need to provide a SCHEMAS clause. > > I suggest starting with the Part 1 Datapump chapter in the Oracle Database > Utilities documentation. Some decent examples and explains all the > parameters and their users. Also maps some common parameters back to the > imp/exp world. > > On Thu, Feb 14, 2008 at 1:58 PM, J. Dex <cemail_219@xxxxxxxxxxx> wrote: > > > 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> > > > > -- J.A. van Zanen