echo off
rem 设置备份的根
set BAKPATH=F:\databak
rem 创建分级目录
if not exist "%BAKPATH%\%date:~0,4%" mkdir %BAKPATH%\%date:~0,4%
if not exist "%BAKPATH%\%date:~0,4%\%date:~5,2%" mkdir %BAKPATH%\%date:~0,4%\%date:~5,2%
rem 备份文件
exp user/pwd@sid file=%BAKPATH%\%date:~0,4%\%date:~5,2%\%date:~0,10%.dmp
rem 设置备份的根
set BAKPATH=F:\databak
rem 创建分级目录
if not exist "%BAKPATH%\%date:~0,4%" mkdir %BAKPATH%\%date:~0,4%
if not exist "%BAKPATH%\%date:~0,4%\%date:~5,2%" mkdir %BAKPATH%\%date:~0,4%\%date:~5,2%
rem 备份文件
exp user/pwd@sid file=%BAKPATH%\%date:~0,4%\%date:~5,2%\%date:~0,10%.dmp