oracle备份还原bat脚本

还原脚本

imp orcl/orcl@orcl file=E:\明天科技\MTEMR\emr20171024.dmp log=E:\MTEMR\1111.log fromuser=mthospital touser=orcl buffer=409600  ignore=n  

用户名/密码/实例名

 

备份脚本

cd C:\users\administrator
exp mthospital/123@TOMORROWEXA file=E:\MTEMR\mthospital161111.dmp buffer=409600 log=E:\MTEMR\mthospital161111.log owner=mthospital

转载于:https://www.cnblogs.com/wangyinlon/p/10905580.html