Re: Data Pump over NETWORK_LINK

From: Jared Still <jkstill_at_gmail.com>
Date: Mon, 20 Apr 2009 16:05:00 -0700
Message-ID: <bf46380904201605n32e8243cl1707eb2f41fdd646_at_mail.gmail.com>

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 - 18:05:00 CDT