Re: Data Pump over NETWORK_LINK

From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Mon, 20 Apr 2009 21:35:21 -0300
Message-ID: <172762180904201735u50fdec63n134706e843050afa_at_mail.gmail.com>

you can use any kind of dblink, the authentication will be done with the schema that executes de import job. In any case, I'd recommend a private dblink, with identified by clause (i.e. write the password of the target schema). That worked for me rather well.

hth
Alan Bort
Oracle Certified Professional

On Mon, Apr 20, 2009 at 8:05 PM, Jared Still <jkstill_at_gmail.com> wrote:

> On Mon, Apr 20, 2009 at 1:05 PM, Xu, Roger <Roger.Xu_at_dpsg.com> wrote:
>
>> Now my question is: how do I do this over the NETWORK_LINK? What kind of
>> DB link I need?
>>
> Just used it last week.
>
> I created a dblink in the target that pointed to a DBA account in the
> source db.
>
> The account for the dblink is the same that is used to run impdp.
>
> Here's one of the impdp commands used:
>
> impdp DBA_ACCOUNT directory=datapump \
> schemas=cqquad \
> logfile=cq_test.log \
> network_link=cq_source
>
> This is was run from the environment of the target databases.
>
> Take a look at the docs, there are more details there.
>
>
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Apr 20 2009 - 19:35:21 CDT