- for /f "tokens=2" %%i in ("%date%") do (
- if exist *.%%i.dmp del *.%%i.dmp
- expdp SEC_SKP/SEC_SKP@WMS DIRECTORY=dmpsecdir DUMPFILE=SEC_SKP.%%i.dmp logfile=SEC_SKP.%%i.log schemas=SEC_SKP
- expdp WMS_SKP/WMS_SKP@WMS DIRECTORY=dmpwmsdir DUMPFILE=WMS_SKP.%%i.dmp logfile=WMS_SKP.%%i.log schemas=WMS_SKP
- )
复制代码
|