#!/bin/sh

# Script to delete the Fiper DB tables for Oracle

if [ $# -lt 2 -o $# -gt 3 ]; then
    echo "usage: droptables username password [ dbName ]"
    exit 1
fi

if [ $# -eq 3 ]; then
    sqlplus -L "$1/$2@$3"  @droptables.sql > droptables.log
else
    sqlplus -L "$1/$2"  @droptables.sql > droptables.log
fi
