Wednesday, June 29, 2011

Example backup batch file

set ORACLE_SID=MYPROJ exp system/******@myuser file=MYPROJ.dmp log=export.log full=y for /f "tokens=1-5 delims= " %%d in ("%date%") do set dayfldr=%%d xcopy MYPROJ.dmp "\\Projects\MYPROJ\Database\Daily_Exports\%dayfldr%\" /Z /R /V /Y

No comments:

Post a Comment