数据泵导数据时加上系统日期

下面是示例，根据实际情况进行修改

 

--下面的是日期时间的格式 
expdp ha_soar/ha_soar@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 

 

--日期格式

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

 

转载于:https://www.cnblogs.com/tianmingt/p/4446408.html