====================Windows======================
expdp username/password@IP:Port/SID schemas=username dumpfile=xxx.dmp
impdp username/password dumpfile=xxx.dmp
(将导出文件放到G:oracle11gadminorcldpdump目录下,执行impdp命令)
举例:
expdp bjuser/BJUser@192.168.1.24/eicdb schemas=bjuser dumpfile=bjuser.dmp
impdp bjuser/BJUser schemas=bjuser dumpfile=bjuser.dmp
=====================Linux=======================
create directory dmppath as '/home/oracle';
grant read , write on directory dmppath to sys;
expdp sys/sys directory=dmppath dumpfile=dmp.dmp full=y;