#!/bin/bash

source ./oracle_env.sh

echo "input oracle tablespace"
read oracle_tb


echo "input initial Size.unit is GB.example: 3 means 3GB"
read oracle_initSize

echo "input next extend size.unit is MB."
read oracle_nextSize

echo "input Max size.unit is GB"
read oracle_maxSize

echo "execute Y|N"
read flag


if [[ $flag == "N" ]];then

  echo "exit "
  exit;

fi

sqlplus / as sysdba @$spath/create_tablespace.sql $oracle_tb $oracle_initSize $oracle_nextSize $oracle_maxSize </dev/null