Oracle Data Pump Detailed (4) network_link

EXPDP's Network_link

As we know, EXPDP the default is to export the local database, the Network_link is to export the remote database to the local server, and its steps are as follows:

Terminology Description:

SOURCE database: Remote Database

Target database: Local database (that is, the server where the EXPDP client is located)

1. Add the connection string of the source database to the Tnsnames.ora on the target database side:

source_db =  
  (DESCRIPTION = (  
    address_list =  
      (address = (PROTOCOL = TCP) (HOST = 192.168.1.15) (PORT = 1521)) 
  
   )  
    (Connect_data =  
      (sid = Orcl)  
    )  
  
  

2. Create DB link in the target database:

Sql>create Public Database link Source_db_link connect to system identified by * * * 

using ' test15 ';  
      
Database link created.  
      
Sql>select instance_name from v$instance@source_db;  
      
instance_name  
----------------  
ORCL

3. Perform EXPDP on the target server:

$ EXPDP System Directory=dump_dir network_link=test15 tables=test.test dumpfile=test.dmp logfile=expdp_test.log

where Network_link equals the db Link,dumpfile,logfile created on step 2nd in the target database Dump_dir

IMPDP's Network_link

The above mentioned EXPDP Network_link is to export the remote database to the local dumpfile, and IMPDP is more powerful and convenient, it can directly import the remote database to the local database, the middle is not even dumpfile generation, its syntax is as follows:

$ IMPDP System Directory=dump_dir network_link=test15 tables=test.test Logfile=impdp_test.log

The above statement directly imports the Test.test table from the source database to the target database, the middle does not produce dumpfile, to produce logfile (logfile placed in the dump_dir of the target database)

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/