Oracle数据库导入导出expdp-impdp

sqlplus /nolog
conn / as sysdba

–创建目录名
create directory data_pump_dir as ‘C:\ora\data’;

–赋权给目录名
grant read,write on directory data_pump_dir to public;

–查看目录名
select * from dba_directories;

–修改目录名
create or replace directory data_pump_dir as ‘D:\oradate’;

–导出用户数据
expdp user/password@ITS directory=data_pump_dir dumpfile=clearing.dmp logfile=user.log schemas=user

–导入用户数据
impdp system/password@ip/oral directory=data_pump_dir dumpfile=user.dmp logfile=user.log EXCLUDE=STATISTICS