Error while using sql loader
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.
What about the environment?
You may need to set the Oracle environment like this:
Code:
logfl=$filename.log.$MYTIME
badfl=$filename.badfile
datfl=$MYFILE
dscfl=$filename.discard
user=$SECUID/$SECPWD@$SECSID
ctlfl=/control/$filename.ctl
ORAENV_ASK=NO
export ORACLE_SID=$SECSID # Or a local SID if $SECSID is remote.
. /usr/local/bin/oraenv
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 "
:rolleyes:
