expdp导出

1、创建导出的目录

create or replace directory expdp_dir as 'd:\exp';

grant read,write on directory expdp_dir to hrb03;

2、执行导出命令

expdp hrb03/hrb03 directory=expdp_dir dumpfile=topicis_hrb03.dmp logfile=topicis_hrb03.log

impdp导入

create or replace directory impdp_dir as 'd:\exp';

grant read,write on directory impdp_dir to hrb03;

执行导入命令

impdp hrb03/hrb03 directory=impdp_dir dumpfile=topicis_hrb03.dmp logfile=topicis_hrb03.log

ITPub博客

data pump总结