Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Example of expdp/impdp over network?

RE: Example of expdp/impdp over network?

From: Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com>
Date: Wed, 5 Apr 2006 19:04:09 +0100
Message-ID: <D97D1FAE0521BD44820B920EDAB3BBAC0BF93F94@ENYC11P32005.corpny.csfb.com>


Mark,  

Yes, indeed.  

Create a dblink on the destination database. Then:  

impdp user/pass directory=<directory> logfile=<logfile> network_link=<the dblink> ...etc. etc.  

Paul Baumgartel
paul.baumgartel_at_credit-suisse.com
212.538.1143

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Bobak, Mark Sent: Wednesday, April 05, 2006 12:26 PM To: oracle-l_at_freelists.org
Subject: Example of expdp/impdp over network?

Hi,

Does anyone have a simple example of how to use expdp/impdp to get data from one 10G database to another via a network link, without writing an intermediate file?

I did some slogging throughg the Utilities manual and some Google searches, but no luck yet.

AdvThanksance,

-Mark

-- 
Mark J. Bobak 
Senior Oracle Architect 
ProQuest Information & Learning 

For a successful technology, reality must take precedence over public relations, for Nature cannot be fooled.  --Richard P. Feynman, 1918-1988




==============================================================================
Please access the attached hyperlink for an important electronic communications disclaimer: http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================
-- http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 05 2006 - 13:04:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US