Oracle数据库迁移

====================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;