expdp远程导入本地

创建DBLINK
create public database link a_link connect system identified by oracle using 'AAAA'
在TNSname.ora中增加解析
AAAA =
(DESCRIPTION =
  (ADDRESS = (PROTOCOL = tcp)(HOST = xx.xx.xx.xx)(PORT = 1521))
  (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = testdb)
  )
)
在sqlplus中测试是否dblink是否成功？
select * from etrade.Tab1@a_link;
创建本地目录：
create directory exp_dir as '/home/oracle/';
grant read,write on directory exp_dir to system;


expdp system/oracle directory=exp_dir network_link=a_link dumpfile=T.dmp schemas=testlogfile=T.log
//system为本地用户名 
//network_link为a_link
//directory目录建在本地
即可实现远程导入本地