1.建db link
创建dblink的语句为
CREATE DATABASE LINK <database link name> CONNECT TO <remote database user name> IDENTIFIED BY <remote database password> USING '<tnsname connect to remote>'
CREATE public DATABASE LINK CC_ECS CONNECT TO CC_ECS IDENTIFIED BY CC_ECS USING '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.8)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))';
2.测试db link
select * from dual@CC_ECS;
3.导库
expdp CC_ECS/CC_ECS schemas=CC_ECS directory=dump dumpfile=CC_ECS_20161216.dmp logfile=CC_ECS_20161216.log network_link=CC_ECS
expdp 本地用户名/密码 schemas=CC_ECS directory=dump dumpfile=CC_ECS_20161216.dmp logfile=CC_ECS_20161216.log network_link=<database link name>