1、select * from v$version 查询要导入的目标数据库版本
2、导出:expdp c##pwp/pwp@orcl dumpfile=d:/local_12c_to_11g.dmp nologfile=Y version=11.2.0.4.0
3、查询数据库设置的directory:SELECT * FROM dba_directories, 将刚刚导出的dmp拷贝至DATA_PUMP_DIR对应目录下
4、导入:impdp pwp/pwp@10.111.58.189:1521/pwp dumpfile=LOCAL_12C_TO_11G.DMP nologfile=Y fromuser=c##pwp touser=pwp
5、select job_name,state from dba_datapump_jobs 查看导入操作是否种终止
注:正确停止导入导出操作:ctrl+c后,export/import> stop_job=immediate ;ctrl+c后导入或导出操作并未终止