数据泵导出 备份文件以日期时间命名

expdp system/system@orcl schemas=wxcqhtba directory=DATA_PUMP_DIR dumpfile=wxcqhtba_%DATE%.dmp logfile=wxcqhtba_%DATE%.log


expdp system/system@orcl schemas=wyzj directory=DATA_PUMP_DIR dumpfile=wyzj_%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%%time:~0,2%%time:~3,2%.dmp logfile=wyzj_%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%%time:~0,2%%time:~3,2%.log

posted on 2015-04-10 10:50  相约future  阅读(460)  评论(0编辑  收藏  举报