impdp 将pdp文件导入oracle数据库

导入数据表
drop directory impdp_path;
create directory impdp_path as '/***/oracle/dump';
grant read,write on directory impdp_dir to mid;

such as:
impdp space_name/password@ip_adress/ORCL DIRECTORY=impdp_path DUMPFILE=LIS.DMP logfile=emr.log
impdp space_name/password@ip_adress/ORCL DIRECTORY=impdp_path DUMPFILE=JYK_DICT.DMP logfile=emr.log
impdp space_name/password@ip_adress/ORCL DIRECTORY=impdp_path DUMPFILE=201812091.PDP logfile=emr.log

posted @ 2019-04-03 10:45  月半仙  阅读(144)  评论(0编辑  收藏  举报