1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
| @echo off
|
| set /p oracle_tb="input oracle tablespace: "
|
| set /p oracle_initSize="input initial Size.unit is GB.example: 3 means 3GB: "
|
| set /p oracle_nextSize="input next extend size.unit is MB.: "
|
| set /p oracle_maxSize="input Max size.unit is GB: "
|
| set sql_path="."
|
| set /p flag="execute Y|N: "
|
|
| if %flag%==Y (sqlplus / as sysdba @%sql_path%\create_tablespace.sql %oracle_tb% %oracle_initSize% %oracle_nextSize% %oracle_maxSize%)
|
|
