#!/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