批处理文件
@echo off
set filename=%DATE:~4,4%%DATE:~9,2%%DATE:~12,2%
set filedir=d:\
echo %filename%
exp sdfxw/123456@oracledb file=%filedir%%filename%.dmp full=y
for /f "skip=7" %%i in ('dir d:\*.dmp /tc /o-d /b') do del %filedir%%%i
此文件加入定时计划
filename 为备份的文件名
%DATE:~4,4%截取date从第四位到后四位的数据
for /f "skip=7" %%i in ('dir *.dmp /tc /o-d /b') do del %filedir%%%i
只保留7条数据 skip=7 %filedir% 文件路径