Oracle Database Batch File

Directory structure

Init script

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

Init.bat

@echo Off@echo---------------------------------------------------------------------@echo ^|               ^| @echo ^|                                                                   Roadside parking System Remote initialization database scripting tool ^| @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 ^|                                                                   Roadside parking System Remote Initialize database script end ^| @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 &user Name;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 .....

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Oracle Database Batch File