Hi,

Im trying to load some data from the csv file to some tables creatred under a schema. The tables are already created. Nad i have placed the data file and control file in the respective directories.

When i treid using sql loader with the below shell script, Im getting some errors.

logfl=$filename.log.$MYTIME
badfl=$filename.badfile
datfl=$MYFILE
dscfl=$filename.discard
user=$SECUID/$SECPWD@$SECSID
ctlfl=/control/$filename.ctl
echo " Loading table $filename "

sqlldr $user $ctlfl log=$logfl bad=$badfl data=$datfl discard=$dscfl
rc=$?
echo .
echo " Completed loading into $filename return code = $rc "



OUTPUT:
Loading table MYTABLE
Message 2100 not found; No message file for product=RDBMS, facility=ULMessage 21
00 not found; No message file for product=RDBMS, facility=UL.
Completed loading into MYTABLE return code = 3


Please let me know where im going wrong.