Oracle expdp数据泵远程导出

2019独角兽企业重金招聘Python工程师标准>>>

create user EXP_USER identified by EXP_USER; 
grant dba to EXP_USER;
-- 注意路径一定要用反斜杠
create directory dump_dir AS 'E:\dump_dir';

create public database link CONNECT_199
  connect to SOFA_DS
  using '192.168.103.199/ORCL';

EXPDP EXP_USER/EXP_USER network_link=CONNECT_199 directory="dump_dir " dumpfile=SOFA.dmp   

 IMPDP SOFA_DS/SOFA_DS   directory="DUMP_TEST " dumpfile=SOFA.dmp

 

 

 

转载于:https://my.oschina.net/liyonglee/blog/669841