====================Windows======================

expdp username/password@IP:Port/SID schemas=username dumpfile=xxx.dmp

impdp username/password dumpfile=xxx.dmp

(将导出文件放到G:\oracle11g\admin\orcl\dpdump目录下,执行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;