SQL*Loader-951: Error calling once/load initialization
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: SQL*Loader-951: Error calling once/load initialization

  1. #1
    Join Date
    Jul 2010
    Posts
    2

    Post SQL*Loader-951: Error calling once/load initialization

    I am loading data from text file into a table through unix script.

    My requirement is that, there are about 200 files in a folder, these data file name should be loaded into the target table. The content of the data file doesn't have the file name. I have done the following steps.

    export data_file
    for data_file in `ls BBT_SHAW*.txt`; do
    sqlldr userid=dwh_user/dwh_user@dwh control=bbt_shaw1.ctl data=$data_file
    done

    the control file is been attached in the attachment.

    When i execute this i am getting the below error.

    SQL*Loader-951: Error calling once/load initialization
    ORA-02373: Error parsing insert statement for table DWH_USER.BBT_SHAW1.
    ORA-00911: invalid character

    Can any one solve this issue.
    Attached Files Attached Files

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

    Cool !Error...

    To get better error reasons do this:
    Code:
    for data_file in `ls BBT_SHAW*.txt`; do
      sqlldr userid=dwh_user/dwh_user@dwh control=bbt_shaw1.ctl \
             data=$data_file log=LOG_$data_file
    done
    and examine the LOG_$data_file log file.
    "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