#! /bin/csh
setenv ORACLE_HOME /usr/oracle
#setenv ORACLE_TERM hft
set path=(. $path $HOME/bin $ORACLE_HOME/bin /usr/local/bin)
setenv ORACLE_SID naos

setenv LOADDIR  /home/R10E/gcheng/database/carrier/load
setenv LOADDATA /home/R10E/gcheng/database/carrier/load
echo ORACLE_SID = $ORACLE_SID
echo $1.tbl
/usr/oracle/bin/sqlldr demo/demo CONTROL=$LOADDIR/$1.ctl,\
LOG=$LOADDIR/$1.log,DATA=$LOADDATA/$1.tbl,BAD=$LOADDIR/$1.bad
echo load $1.tbl done !
exit

