21 lines
1.1 KiB
Batchfile
21 lines
1.1 KiB
Batchfile
if /i "%1%"=="" goto Error
|
|
echo 正在删除表、序列、视图...
|
|
sqlplus %1% @ScriptFile\DropTables_Sequences_Views.sql
|
|
echo 正在恢复数据库...
|
|
imp %1% file=datafile\highway_storage.dmp rows=y fromuser=(highway_storage) touser=(highway_storage) destroy=y ignore=y commit=y log=datafile\highway_storage_imp.log
|
|
imp %1% file=datafile\highway_running.dmp rows=y fromuser=(highway_running) touser=(highway_running) destroy=y ignore=y commit=y log=datafile\highway_running_imp.log
|
|
imp %1% file=datafile\highway_history.dmp rows=y fromuser=(highway_history) touser=(highway_history) destroy=y ignore=y commit=y log=datafile\highway_history_imp.log
|
|
imp %1% file=datafile\highway_selldata.dmp rows=y fromuser=(highway_selldata) touser=(highway_selldata) destroy=y ignore=y commit=y log=datafile\highway_selldata_imp.log
|
|
imp %1% file=datafile\highway_exchange.dmp rows=y fromuser=(highway_exchange) touser=(highway_exchange) destroy=y ignore=y commit=y log=datafile\highway_exchange_imp.log
|
|
|
|
goto End
|
|
:Error
|
|
@echo off
|
|
cls
|
|
echo ---------------------------------------------
|
|
echo 请从00_批处理脚本.bat打开。
|
|
echo ---------------------------------------------
|
|
pause>nul
|
|
exit
|
|
:End
|