bat 执行exp,zip,sql

xx.bat:

@echo on
set d=%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%
set DIRECTORY=D:\itms
if not exist "%DIRECTORY%"     mkdir %DIRECTORY%
exp user_name/pass@10.10.10.92/orcl file=%DIRECTORY%\LOG_LESS20180326.dmp log=%DIRECTORY%\LOG_LESS20180326.log tables=LOG_LESS20180326
@echo on
zip -m %DIRECTORY%\LOG_LESS20180326.zip %DIRECTORY%\LOG_LESS20180326.dmp
@echo on
start sqlplus /nolog @"xx.sql"

 

xx.sql:

conn user_name/pass@10.10.10.92/orcl
drop table LOG_LESS20180326 purge;
exit;