首页 > 数据库技术 > 详细

expdp dblink

时间:2018-11-19 18:56:08      阅读:147      评论:0      收藏:0      [点我收藏+]

客户端创建dblik

create public database link [link_name]  connect to  {username} identified by "{password}"
using ‘(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)))‘

  

导出数据

expdp {username}/{password}  directory=backup2 network_link=[link_name] dumpfile=ydm_20181119_2.dmp logfile=ydm_20181119_2.log EXCLUDE=STATISTICS

  

 

expdp dblink

原文:https://www.cnblogs.com/sweet22353/p/9984585.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!