`

xxx.bat关于导出oracle备份

 
阅读更多

@echo on
exp wms/wms@149.208.108.106:1521/wms210 file=D:\data_back_210\wms210_%date:~0,4%%date:~5,2%%date:~8,2%_"%time:~0,2%%time:~3,2%".dmp
pause

 

生成结果:wms210_20130925_1904.dmp

结果分析:%date:~0,4%==2013

                 %date:~5,2%==0925

                 "%time:~0,2%%time:~3,2%"==1904(时间转换成字符串用" ")

                 pause=自动截至

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics