oracle导入导出dmp

exp isc/isc@orcl file=d:\isc.dmp full=y

exp bpm/bpm@orcl file=d:\bpm.dmp full=y

 

 

imp isc/isc@orcl file=d:\isc201708.dmp full=y ignore=y

imp bpm/bpm@orcl file=d:\bpm201708.dmp full=y

 

 

 

 

imp isc/isc@orcl file=d:\isc.dmp full=y ignore=y

 

 

 

//导出指定用户数据库（试过可用）

exp trainCheck/123456@orcl file=d:\oraclebackup\trainCheck.dmp log=D:\oraclebackup\trainCheck.log owner=(trainCheck2)

 

//导入（试过可用）

imp test/123456@orcl file=d:\oraclebackup\test.dmp log=D:\oraclebackup\test.log full=y