!!!先确定两个数据库版本是否一致,不一致expdp需要加入version=导入数据库版本
su - oracle;
sqlplus/as sysdba;
create or replace directory data_dumpas'/opt/expdb/20180714';
grant write,read on directory data_dump to ytzq_new_web;
exit;
//导出
expdp name/password schemas=name directory=data_dump
dumpfile=20180714.dmp logfile=20180714.log;
//导入
impdp name/password directory=data_dump dumpfile=20180714.dmp
schemas=name table_exists_action=truncate;
window命令提示符下直接从sqlpus/assysdba;开始执行。