1)新建backup.bat文件如下
@echo off
exp LW10/supcon@orcl file=C:\BACKUP\LW10_%date:~0,4%%date:~5,2%%date:~8,2%.dmp log=C:\BACKUP\LW10_%date:~0,4%%date:~5,2%%date:~8,2%.log
@exit
2)C盘新建BACKUP文件夹
3)创建定时任务
4)执行bat文件进行备份
1)新建backup.bat文件如下
@echo off
exp LW10/supcon@orcl file=C:\BACKUP\LW10_%date:~0,4%%date:~5,2%%date:~8,2%.dmp log=C:\BACKUP\LW10_%date:~0,4%%date:~5,2%%date:~8,2%.log
@exit
2)C盘新建BACKUP文件夹
3)创建定时任务
4)执行bat文件进行备份