下面是自己写的一个批处理“expdata.bat”文件,功能把 table1 和 table2 的数据备份到D盘的OracleDate目录下,以当前日期做为文件名set LOCAL_DIR=D:\OracleData
set TODAY=%date%
set TODAY=%TODAY:~0,10%
set TODAY=%TODAY:-=%
set BACKUP_FILE=%LOCAL_DIR%\part%TODAY%.dmp
set LOG_FILE=%LOCAL_DIR%\expdatalog%TODAY%.log
exp user/user@orcl file=%BACKUP_FILE% log=%LOG_FILE% tables=(table1,table2) rows=y indexes=y compress=n然后我把这二个表的数据清空,如果才能把刚才备份的数据恢复回去。用批处理来完成
set TODAY=%date%
set TODAY=%TODAY:~0,10%
set TODAY=%TODAY:-=%
set BACKUP_FILE=%LOCAL_DIR%\part%TODAY%.dmp
set LOG_FILE=%LOCAL_DIR%\expdatalog%TODAY%.log
exp user/user@orcl file=%BACKUP_FILE% log=%LOG_FILE% tables=(table1,table2) rows=y indexes=y compress=n然后我把这二个表的数据清空,如果才能把刚才备份的数据恢复回去。用批处理来完成
set TODAY=%date%
set TODAY=%TODAY:~0,10%
set TODAY=%TODAY:-=%
set BACKUP_FILE=%LOCAL_DIR%\part%TODAY%.dmp
set LOG_FILE=%LOCAL_DIR%\impdatalog%TODAY%.log
imp user/user@orcl file=%BACKUP_FILE% log=%LOG_FILE% full=y ignore=y