oracle-impdp导入数据

第一：dmp文件上传到/picclife/app/oracle/admin/xcalcpro/dpdump目录下

第二：创建directory路径
sqlplus / as sysdba

create or replace directory PATH as '/picclife/app/oracle/admin/xcalcpro/dpdump';
grant read,write on directory PATH to basic;
grant read,write on directory PATH to basic_uap;
grant read,write on directory PATH to basic_security;
grant read,write on directory PATH to basic_taskconf;

第三：导入数据
impdp 'basic/"RgPt,789#1115"' directory=PATH dumpfile=newtouchbasic.dmp logfile=newtouchbasic.log remap_schema=newtouchbasic:basic remap_tablespace=NEWTOUCH_BASIC:basic,EFMIS:basic

impdp 'basic_uap/"RgPt,789#1115"' directory=PATH dumpfile=newtouch_uap.dmp logfile=newtouch_uap.log remap_schema=newtouch_uap:basic_uap remap_tablespace=uap:basic_uap