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

Threaded View

  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

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