#!/bin/bash source ./oracle_env.sh echo "input oracle user" read oracle_user echo "input password" read oracle_password echo "input default tablespace" read oracle_tablespaces echo "execute Y|N" read flag if [[ $flag == "N" ]];then echo "exit " exit; fi sqlplus / as sysdba @$spath/create_user.sql $oracle_user $oracle_password $oracle_tablespaces