#! /bin/csh

setenv ORACLE_HOME /usr/oracle
set path=(. $path $HOME/bin $ORACLE_HOME/bin /usr/local/bin)
setenv ORACLE_SID nodb
setenv ORACLE_PSRV nodb

setenv LOADDIR  /tmp/gcheng
setenv table url

sqlldr gcheng/gcheng DATA=$LOADDIR/$table.tbl, \
CONTROL=$LOADDIR/$table.ctl,\
LOG=$LOADDIR/$table.log,BAD=$LOADDIR/$table.bad

exit
