expdp远程导dump文件到本地

最新推荐文章于 2024-07-08 13:55:42 发布

lyb3290

最新推荐文章于 2024-07-08 13:55:42 发布

阅读量515

点赞数

分类专栏： Data-mysql+oracle+redis+mongo

本文链接：https://blog.csdn.net/lyb3290/article/details/53692019

版权

Data-mysql+oracle+redis+mongo 专栏收录该内容

9 篇文章 0 订阅

订阅专栏

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>