rem 假设f:\data_backup是要保存备份数据的目录 @echo off setlocal pushd f:\data_backupif NOT EXIST file.lst copy nul file.lst set i=1 set maxfiles=7 set NEWFILENAME=dbname%date:~4,10%.dmpexp username/password owner=username file=%NEWFILENAME%echo %i%:%NEWFILENAME%>file.lst.tmp for /F "tokens=2 delims=:" %%F in (file.lst) do call :check "%%F" copy file.lst.tmp file.lst endlocal goto :EOF:check set /a i=i+1 set tmpfilename=%~1 if %i% GTR %maxfiles% ( if EXIST "%tmpfilename%" del "%tmpfilename%" ) else echo %i%:%tmpfilename%>>file.lst.tmp goto :EOF
想要的话加我的QQ:20322267
谢谢tigi(流星雨)、 chengtwn(漠孤烟) 的热心回答以及18687874(别拿苹果扔我) 的关注!
@echo off
setlocal
pushd f:\data_backupif NOT EXIST file.lst copy nul file.lst
set i=1
set maxfiles=7
set NEWFILENAME=dbname%date:~4,10%.dmpexp username/password owner=username file=%NEWFILENAME%echo %i%:%NEWFILENAME%>file.lst.tmp
for /F "tokens=2 delims=:" %%F in (file.lst) do call :check "%%F"
copy file.lst.tmp file.lst
endlocal
goto :EOF:check
set /a i=i+1
set tmpfilename=%~1
if %i% GTR %maxfiles% (
if EXIST "%tmpfilename%" del "%tmpfilename%"
) else echo %i%:%tmpfilename%>>file.lst.tmp
goto :EOF
%some_var%%some_var:~x,y% = substr(some_var,x,y)做笔记...
导出
>expdp king/520 tables=new directory=DPDATA1 dumpfile=expcases_%u.dmp parallel=4 job_name=cases_export
导入:
>impdp king/520 directory=dpdata1 dumpfile=expcases_%u.dmp job_name=cases_import