Oracle导库

sqlplus / as sysdba
select * from dba_directories;

create directory PPMDUMP as ‘/oracle/dump‘;

grant read,write on directory PPMDUMP to public;
grant exp_full_database to PPMDUMP;
expdp PPMCL/PPMCL schemas=PPMCL directory=PPMDUMP dumpfile=ppm0516.dump logfile=ppmdump.log ;

这里要先建用户，分大小，我没有权限。

impdp PPMTEST/PPMTEST123 directory=PPMDUMP dumpfile=ppm0516.dump REMAP_SCHEMA=PPMCL:PPMTEST logfile=ppmimpdp.log

Oracle导库

原文：https://www.cnblogs.com/zephyr-1/p/10918078.html