19 lines
837 B
Batchfile
19 lines
837 B
Batchfile
if /i "%1%"=="" goto Error
|
|
echo 正在删除表、序列、视图...
|
|
sqlplus %1% @ScriptFile\DropTables_Sequences_Views.sql
|
|
echo 正在恢复数据库...
|
|
imp %1% file=datafile\contract_storage.dmp rows=y fromuser=(contract_storage) touser=(contract_storage) destroy=y ignore=y commit=y log=datafile\contract_storage_imp.log
|
|
imp %1% file=datafile\contract_running.dmp rows=y fromuser=(contract_running) touser=(contract_running) destroy=y ignore=y commit=y log=datafile\contract_running_imp.log
|
|
imp %1% file=datafile\contract_history.dmp rows=y fromuser=(contract_history) touser=(contract_history) destroy=y ignore=y commit=y log=datafile\contract_history_imp.log
|
|
|
|
goto End
|
|
:Error
|
|
@echo off
|
|
cls
|
|
echo ---------------------------------------------
|
|
echo 请从00_批处理脚本.bat打开。
|
|
echo ---------------------------------------------
|
|
pause>nul
|
|
exit
|
|
:End
|