一、创建dblink
create public database link linkname_xxx connect to 远程数据库账号 identified by 远程数据库密码
using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)
(HOST = 远程地址)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME
= 数据库名称)))’;
二、导出数据
expdp test/abc123@orcl directory=DUMP_DIR dumpfile=eas32.dmp network_link=linkname_xxx