Import data via a network link

 

Have you find yourself you need import a export from other server and this dump not fit in any filesytem.
Solution is very simple,from Oracle 10g now you can use network to import data from a remote database

In Oracle 10g, the Data Pump version of import can eliminate the dump file entirely by importing directly from another database instance.

The only limitation is that network_link option doesn’t support tables with LONG Columns.

steps…

1) Define database link

define dblink object to identofy database source. For example: source database in London with oracle service name LON

CREATE DATABASE LINK london CONNECT TO user1 IDENTIFIED BY temp01 USING ‘LON’;

this user have correct privileges to to access the data to be imported

2) Data Pump import
The Data Pump import command, impdp, can now use this database link to directly access remote data. The command line parameter NETWORK_LINK points to the source database via its database link.

On the local database instance in Madrid, user user2:

impdp user2/tempo03 TABLES=customers,sales DIRECTORY=dpump01 NETWORK_LINK=london

No export will be performed on the instance in London, and no dump file created.

Advertisements

Comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s