Re: impdp one user only

From: Bradd Piontek <piontekdd_at_gmail.com>
Date: Thu, 14 Feb 2008 14:04:03 -0600
Message-ID: <e9569ef30802141204t3efb1feo9d44e6e5224a8986@mail.gmail.com>


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>
>

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

Original text of this message