Oracle 数据泵导入导出

%查询directory 目录

select * from dba_directories;

imp zminfo/zminfo fromuser=zminfo touser=zminfo file=E:zBONDDT.dmp log=e:onddt.log buffer=1000000000 ignore=y;

create directory tmp_dmp as 'D:/';
grant read, write on directory tmp_dmp to zminfo;
impdp zminfo/zminfo dumpfile=Bonddt.dmp directory=tmp_dmp logfile=import.log full=y nologfile=yes
drop directory tmp_dmp

create directory tmp_dmp as 'D:/';
grant read, write on directory tmp_dmp to zminfo;
impdp zminfo/zminfo dumpfile=BYIELDCURVE.dmp directory=tmp_dmp logfile=import1.log full=y nologfile=yes
drop directory tmp_dmp
expdp zminfo/zminfo dumpfile=zminfo.dmp directory=tmp_dmp

impdp CAIHUI/CAIHUI dumpfile=BYIELDCURVE.dmp directory=tmp_dmp logfile=import.log full=y REMAP_SCHEMA=ZMINFO:CAIHUI

exp zminfo/zminfo@CAIHUIRISK file=D:NAV.dmp tables=(NAV) log=D:exp20150421NAV.log