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

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

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

原文：http://www.cnblogs.com/tianmingt/p/4413937.html