Oracle Dump windows batch脚本

Save the following lines as content of file dump.bat:

 

set date_string=%date:~0,4%_%date:~5,2%_%date:~8,2% set time_string=%time:~0,2%_%time:~3,2%_%time:~6,2% set file_string=E:/db/backup_%date:~0,4%_%date:~5,2%_%date:~8,2%_%time:~0,2%_%time:~3,2%_%time:~6,2%

exp user/pwd@schema buffer=20000000 file=%file_string%.dmp tables=(table1,table2)

 

 

Run dump.bat will dump the data into files.