21 lines
1.2 KiB
Batchfile
21 lines
1.2 KiB
Batchfile
if /i "%1%"=="" goto Error
|
|
echo 正在删除表、序列、视图...
|
|
sqlplus %1% @ScriptFile\DropTables_Sequences_Views.sql
|
|
echo 正在恢复数据库...
|
|
imp %1% file=datafile\SaleStore_storage.dmp rows=y fromuser=(SaleStore_storage) touser=(SaleStore_storage) destroy=y ignore=y commit=y log=datafile\SaleStore_storage_imp.log
|
|
imp %1% file=datafile\SaleStore_running.dmp rows=y fromuser=(SaleStore_running) touser=(SaleStore_running) destroy=y ignore=y commit=y log=datafile\SaleStore_running_imp.log
|
|
imp %1% file=datafile\SaleStore_history.dmp rows=y fromuser=(SaleStore_history) touser=(SaleStore_history) destroy=y ignore=y commit=y log=datafile\SaleStore_history_imp.log
|
|
imp %1% file=datafile\SaleStore_selldata.dmp rows=y fromuser=(SaleStore_selldata) touser=(SaleStore_selldata) destroy=y ignore=y commit=y log=datafile\SaleStore_selldata_imp.log
|
|
imp %1% file=datafile\SaleStore_exchange.dmp rows=y fromuser=(SaleStore_exchange) touser=(SaleStore_exchange) destroy=y ignore=y commit=y log=datafile\SaleStore_exchange_imp.log
|
|
|
|
goto End
|
|
:Error
|
|
@echo off
|
|
cls
|
|
echo ---------------------------------------------
|
|
echo 请从00_批处理脚本.bat打开。
|
|
echo ---------------------------------------------
|
|
pause>nul
|
|
exit
|
|
:End
|