编辑 exp_1.bat
exp aaa/aaa@test tables=tt_area file=I:11tt_area%date:~0,4%%date:~5,2%%date:~8,2%.dmp log=I:11tt_area%date:~0,4%%date:~5,2%%date:~8,2%.log
导出的结果是:tb_area20090918.dmp ,tb_area20090918.log
或者 set "ymd=%date:~0,4%%date:~5,2%%date:~8,2%"
set "ymd=%date:~0,4%"
set "mm=%date:~5,2%"
set "dd=%date:~8,2%"
exp aaa/aaa@test tables=tt_area file=I:11tt_area_%ymd%%mm%%dd%.dmp log=I:11tt_area_%ymd%%mm%%dd%.log
或者
set "ymd=%date:~0,4%%date:~5,2%%date:~8,2%"
exp aaa/aaa@test tables=tt_area file=I:11tt_area%ymd%.dmp log=I:11tt_area%ymd%.log
编辑 exp_1.bat
exp aaa/aaa@test tables=tt_area file=I:11tt_area%date:~0,4%%date:~5,2%%date:~8,2%.dmp log=I:11tt_area%date:~0,4%%date:~5,2%%date:~8,2%.log
导出的结果是:tb_area20090918.dmp ,tb_area20090918.log
或者 set "ymd=%date:~0,4%%date:~5,2%%date:~8,2%"
set "ymd=%date:~0,4%"
set "mm=%date:~5,2%"
set "dd=%date:~8,2%"
exp aaa/aaa@test tables=tt_area file=I:11tt_area_%ymd%%mm%%dd%.dmp log=I:11tt_area_%ymd%%mm%%dd%.log
或者
set "ymd=%date:~0,4%%date:~5,2%%date:~8,2%"
exp aaa/aaa@test tables=tt_area file=I:11tt_area%ymd%.dmp log=I:11tt_area%ymd%.log
控制面板 ----->计划任务----->新增计划任务，最后填入密码 就OK 啦
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/66233/viewspace-1027102/ ，如需转载，请注明出处，否则将追究法律责任。
