oracle 資料庫批次檔

標籤：

目錄結構

初始化指令碼

 |----orcl_sql|----init_user.sql|----tab_home.sql        |----TAB_USER.sql |----init.bat

init.bat

@echo off@echo ---------------------------------------------------------------------@echo ^|                                                                   ^|@echo ^|               路邊停車系統遠程初始化資料庫指令碼工具                ^|@echo ^|                                                                   ^|@echo --------------------------------------------------------------------- @echo ^|if exist orcl_sql/parmeter.sql (cd orcl_sqldel -p parmeter.sqlcd ..)set ip=127.0.0.1set port=1521set sid=orclset managerName=systemset password=adminset newUserName=testset newUserPWD=test@echo ^|   ip : 127.0.0.1@echo ^|   port : 1521@echo ^|   sid : orcl@echo ^|   managerName : system@echo ^|   password : admin@echo ^|   newUserName : test@echo ^|   newUserPWD : testrem set /p ip=^|   ip : rem set /p port=^|   port : rem set /p sid=^|   sid : rem set /p managerName=^|   managerName : rem set /p password=^|   password : rem set /p newUserName=^|   newUserName : rem set /p newUserPWD=^|   newUserPWD : @echo define userName=%newUserName%> orcl_sql/parmeter.sql@echo define password=%newUserPWD%>> orcl_sql/parmeter.sql@echo @orcl_sql/init_user.sql>> orcl_sql/parmeter.sqlif not exist C:\TABLESPACE (md C:\TABLESPACE)sqlplus %managerName%/%password%@%ip%:%port%/%sid% @orcl_sql/parmeter.sqlif exist orcl_sql/parmeter.sql (cd orcl_sqldel -p parmeter.sqlcd ..)sqlplus %newUserName%/%newUserPWD%@%ip%:%port%/%sid% @orcl_sql/tab_home.sql@echo ^|                                                      @echo ---------------------------------------------------------------------@echo ^|                                                                   ^|@echo ^|               路邊停車系統遠程初始化資料庫指令碼結束                ^|@echo ^|                                                                   ^|@echo --------------------------------------------------------------------- pause

init_user.sql

CREATE TABLESPACE TABLESPANCE_PARK DATAFILE 'C:\TABLESPACE\PARK.DBF' SIZE 1000M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;     CREATE USER &userName IDENTIFIED BY &password DEFAULT TABLESPACE TABLESPANCE_PARK;  GRANT CREATE TABLE,CREATE VIEW,CREATE TRIGGER, CREATE SEQUENCE,CREATE PROCEDURE TO &userName;GRANT UNLIMITED TABLESPACE TO &userName; GRANT CREATE SESSION TO &userName;grant select on v_$statname to &userName;grant select on v_$sesstat to &userName;grant select on v_$session to &userName;grant select on v_$mystat to &userName;EXIT;

</pre><strong><span style="font-size:24px"></span></strong><pre name="code" class="plain">

tab_home.sql

@orcl_sql/TAB_USER.sql@orcl_sql/TAB_ROLE.sql@orcl_sql/TAB_MENU.sql..........

著作權聲明：本文為博主原創文章，未經博主允許不得轉載。

oracle 資料庫批次檔