Oracle export db batch file

@ECHO OFF


set ORACLE_SID=ORCL

for /f "tokens=1-4 delims=/ " %%a in ('date /t') do (
set DATE=%%c-%%b-%%d
set Month=%%b
set Year=%%d)
for /f "tokens=1-3 delims=: " %%a in ('time /t') do (
set hours=%%a
set minutes=%%b
set ampm=%%c
)

if {%ampm%}=={AM} if {%hours%}=={12} set hours=00
if {%ampm%}=={PM} (
for /f "delims=0 tokens=*" %%a in ("%hours%") do set hours=%%a
set /a hours+= 12
)

if %Month%==01 set Month=JAN
if %Month%==02 set Month=FEB
if %Month%==03 set Month=MAR
if %Month%==04 set Month=APR
if %Month%==05 set Month=MAY
if %Month%==06 set Month=JUN
if %Month%==07 set Month=JUL
if %Month%==08 set Month=AUG
if %Month%==09 set Month=SEP
if %Month%==10 set Month=OCT
if %Month%==11 set Month=NOV
if %Month%==12 set Month=DEC

set devDBBackupPath=\DEV\MSTR_VERSION_9_0_1
set devDB=mstrmetadata

if NOT exist %Month%-%Year%\%devDBBackupPath% (
mkdir %Month%-%Year%\%devDBBackupPath%
 )
@ECHO ---------------------------------------------------
@ECHO Exporting MSTR VERSION 9.0.1 METADATA ( %devDB% ) ............
@ECHO ---------------------------------------------------

set devDBBackupPath=%Month%-%Year%\%devDBBackupPath%

exp %devDB%/str0ng@%ORACLE_SID% file=%devDBBackupPath%\%devDB%_%date%_%hours%.%minutes%_%ampm%.dmp log=%devDBBackupPath%\%devDB%_%date%_%hours%.%minutes%_%ampm%.log

zip -jj .\%devDBBackupPath%\%devDB%_%date%_%hours%.%minutes%_%ampm%.zip %devDBBackupPath%\%devDB%_%date%_%hours%.%minutes%_%ampm%.*

DEL %devDBBackupPath%\%devDB%_%date%_%hours%.%minutes%_%ampm%.dmp
DEL %devDBBackupPath%\%devDB%_%date%_%hours%.%minutes%_%ampm%.log



@ECHO ---------------------------------------------------
@ECHO %devDB% Exported successfully
@ECHO ---------------------------------------------------