<commit_before>usage() {
  echo "Usage: $0 username password dbname tablespace dbdir"
}

# Username
USER=$1

#Password
PASSWD=$2

#DBNAME
DBNAME=$3

#TableSpace
TBS=$4

#DBDIR
DBDIR=$5

# Default Log Dir
DEFAULT_LOG_DIR=logs

if [ "x$USER" = "x" ] || [ "x$PASSWD" = "x" ] || [ "x$DBNAME" = "x" ] || [ "x$TBS" = "x" ] || [ "x$DBDIR" = "x" ] 
then
  usage
  exit 1
fi

TBS_LC=`echo $TBS | tr '[A-Z]' '[a-z]'`
TBS_UC=`echo $TBS | tr '[a-z]' '[A-Z]'`

echo "INFO: creating user and tablespace"
sqlplus system/manager\@${DBNAME} as sysdba << __EOF__ 
drop tablespace ${TBS_UC} including contents;
drop tablespace ${TBS_UC}_IDX including contents;<commit_msg>cosmetic: nuke two trailing spaces<commit_after>usage() {
  echo "Usage: $0 username password dbname tablespace dbdir"
}

# Username
USER=$1

#Password
PASSWD=$2

#DBNAME
DBNAME=$3

#TableSpace
TBS=$4

#DBDIR
DBDIR=$5

# Default Log Dir
DEFAULT_LOG_DIR=logs

if [ "x$USER" = "x" ] || [ "x$PASSWD" = "x" ] || [ "x$DBNAME" = "x" ] || [ "x$TBS" = "x" ] || [ "x$DBDIR" = "x" ]
then
  usage
  exit 1
fi

TBS_LC=`echo $TBS | tr '[A-Z]' '[a-z]'`
TBS_UC=`echo $TBS | tr '[a-z]' '[A-Z]'`

echo "INFO: creating user and tablespace"
sqlplus system/manager\@${DBNAME} as sysdba << __EOF__
drop tablespace ${TBS_UC} including contents;
drop tablespace ${TBS_UC}_IDX including contents;
{'fraction_non_alphanumeric': 0.18943396226415093, 'fraction_numerical': 0.010566037735849057, 'mean_word_length': 4.548117154811716, 'pattern_counts': {'":': 0, '<': 7, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '6698267', 'n_tokens_mistral': 576, 'n_tokens_neox': 565, 'n_words': 143}