环境背景:
本地 :IP:127.0.0.1 端口:1521 实例:orcl 用户:local_sys/123
远程服务器:IP:192.168.0.100 端口:1521 实例:orcl 用户:server_sys/123
目标:将服务器上server_user1用户导出到本地
1.登录本地数据库
C:\Users\admin>sqlplus / as sysdba
2.创建dblink
create database link DBLINK_NAME connect to system identified by orcl using 'TO_SERVER=(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.100)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)';
3.创建数据库目录
create directory MY_DIR as 'd:\dump';
grant write,read on directory MY_DIR to local_sys;
4.导出
expdp local_sys/123@127.0.0.1:1521/orcl network_link=local_to_server directory=MY_DIR dumpfile=result.dmp logfile=result.log SCHEMAS=server_user1
参考文章:
http://blog.csdn.net/jc_workspace/article/details/68940709