Re: Data Pump over NETWORK_LINK
- From: Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>
- To: jkstill@xxxxxxxxx
- Date: Mon, 20 Apr 2009 21:35:21 -0300
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@xxxxxxxxx> wrote:
> On Mon, Apr 20, 2009 at 1:05 PM, Xu, Roger <Roger.Xu@xxxxxxxx> 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
>
>
>
Other related posts:
