简单的windows下使用任务计划做oracle exp备份

一.在windows上安装oracle客户端

二.写批处理文件

del /Q e:oraback*.*
if "%time:~0,1%"==" " (set backup_file=%date:~4,4%%date:~9,2%%date:~12,2%-0%time:~1,1%%time:~3,2%%time:~6,2%) else (set

backup_file=%date:~4,4%%date:~9,2%%date:~12,2%-%time:~0,2%%time:~3,2%%time:~6,2%)

exp system/passwd@orasid file= e:oraback%backup_file%.dmp log= e:oraback%backup_file%.log full = y

e:oraback 修改成 e:oraback加右斜杠""

[@more@]

三.在windows任务计划中建立任务

请使用浏览器的分享功能分享到微信等