1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
| #!/bin/bash
|
| source ./oracle_env.sh
|
| echo "input oracle tablespace"
| read oracle_tb
|
|
|
| echo "execute Y|N"
| read flag
|
|
| if [[ $flag == "N" ]];then
|
| echo "exit "
| exit;
|
| fi
|
| sqlplus / as sysdba @$spath/drop_tablespace.sql $oracle_tb </dev/null
|
|
