oracle impdp

导入数据总报错:oracle impdp 无法打开日志文件 windows10

原因:目录写的不对,带了文件名;或者包含了中文?疑惑;

解决:

create directory dpdata3 as 'C:data';
create directory dpdata4 as 'C:datazkmisdmp';

select * from dba_directories;
grant read,write on directory dpdata3 to newspecialty;

grant read,write on directory dpdata4 to zkmis;
-- cmd execute
impdp zkmis/zkmis@ORCLPDB DIRECTORY=dpdata4 dumpfile=zkmis_01.dmp,zkmis_02.dmp,zkmis_03.dmp,zkmis_04.dmp FULL=y 
impdp newspecialty/newspecialty@ORCLPDB DIRECTORY=dpdata3 dumpfile=NEWSPECIALTY1030.dmp remap_tablespace= newspecialty_temp:newspecialty

  

www.beicaiduo.com
原文地址:https://www.cnblogs.com/hoge66/p/13957856.html