Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> hi stephen,

hi stephen,

From: Narender Akula <Narender.Akula_at_telecom.co.nz>
Date: Wed, 12 Jul 2000 11:06:50 +1200
Message-Id: <10555.111737@fatcity.com>


hi stephen,
You can do this by writing a shell script. I have done this by loading = multiple infiles
at commnad line.=20

usage $junk_load.sh a.ctl b.ctl c.ctl
----------junk_load-----

SPOOLFILE=3D/tmp/junk_load.$$  =20
INFILES=3D$*                   =20
DDAT=3D$$.`date "+%Y%m%d"`     =20
LOGFILE=3D/tmp/ctel_load.$DDAT =20
CTLFILES=3D`ls -1 $INFILES 2>/dev/null`                    =20

=20
if [ ! "$CTLFILES" ] =20 then =20 echo "ERROR. $INFILES not found." =20 echo "$0 cancelled at `date`" =20 exit 1 =20 fi =20
=20
#More than one file could be found, so process all of them. for i in $CTLFILES =20 do =20 echo "Processing $i..." =20

sqlload userid=3Dscott/tiger control=3D$i data=3Ddata1.txt silent=3Dheade= r,feedback errors=3D10000 bad=3D/tmp/$i.bad log=3D/tmp/$i.log=20 done
  echo "$0 completed at `date`" =20 Received on Tue Jul 11 2000 - 18:06:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US