当前位置:Gxlcms > 数据库问题 > expdp dblink

expdp dblink

时间:2021-07-01 10:21:17 帮助过:18人阅读

客户端创建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

标签:ack   客户   des   dmp   base   statistic   data   net   service   

人气教程排行