expdp

1，创建os目录
oracle用户创建
mkdir /home/oracle/dbbak
chomod -R 755 /home/oracle/dbbak

2，创建DB目录

drop directory dbbak;
create directory dbbak as '/home/oracle/dbbak';
grant read,write on directory dbbak to system;

select privilege, directory_name, directory_path
from user_tab_privs t, all_directories d
where t.table_name(+) = d.directory_name order by 2, 1;

3，执行命令
impdp system/oracle@jydb schemas=db_user dumpfile=db_user_exp.dmp directory=dbbak logfile='db_user_imp.log'

转载于:https://www.cnblogs.com/timlong/p/5963149.html