Oracle建立database link 及expdp impdp

建立database link 及expdp impdp

  建立database link

 create database link XXXX connect to  XXXX identified by XXXX using 'IP/orcl';

 create database link XXXX connect to XXXX identified by XXXX using 'IP/orcl';

这是Oracle 连接Oracle  的

这是数据泵语法

expdp portal_his/bsoft@qzhis schemas=user1,user2,user3  directory=dpbak dumpfile =expdp20170515.dmp logfile=expdp20170515.log

impdp system/oracle DIRECTORY=dmp_data dumpfile =EXPDP20170515.dmp logfile=imPDP20170515_mh.log SCHEMAS=user1