#!/bin/sh

# Script to clear the Fiper DB tables for Oracle

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

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


