Re: impdp one user only

From: Jack van Zanen <jack_at_vanzanen.com>
Date: Fri, 15 Feb 2008 08:20:04 +1100
Message-ID: <77a615a70802141320l316b3921ldf55c47259288734@mail.gmail.com>


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_at_gmail.com> 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_at_hotmail.com> 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

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 14 2008 - 15:20:04 CST

Original text of this message