写个.bat的程序，内容为

exp scott/tiger@192.168.56.11/prod file=D:\scott%date:~0,4%%date:~5,2%%date:~8,2%.dmp log=D:\scott%date:~0,4%%date:~5,2%%date:~8,2%.txt

rem delete 10days files

forfiles /p "d:\bak" /d -10 /c "cmd /c echo deleting @file ... && del /f @path"

备份出来的是 scott20141027.dmp

exp system/oracle@192.168.56.11/prod full=y file=D:\full%date:~0,4%%date:~5,2%%date:~8,2%.dmp log=D:\full%date:~0,4%%date:~5,2%%date:~8,2%.txt

ITPub博客

windowns系统下oracle数据库exp自动备份