#!/bin/bash
source ./oracle_env.sh
echo "input oracle directory"
read oracle_dir

echo "input oracle path"
read oracle_path

echo "input user who you grant write,read on directory"
read oracle_user

echo "execute Y|N"
read flag


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

  echo "exit "
  exit;

fi

sqlplus / as sysdba @$spath/create_dir.sql $oracle_dir $oracle_path $oracle_user </dev/null