#!/bin/ksh export ORACLE_SID=`echo ${1} | tr [:lower:] [:upper:]` export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1/ export SCRIPTS="/home/oracle/LJ/smart_update" $ORACLE_HOME/bin/sqlplus / as sysdba @${SCRIPTS}/SMART_UPDATES.SQL