Error while using sql loader
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Error while using sql loader

  1. #1
    Join Date
    Jan 2010
    Posts
    20

    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.

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,471

    Cool 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 "
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width