Results 1 to 2 of 2

Thread: sqlldr problem

  1. #1
    Join Date
    Mar 2007
    Posts
    3

    Unanswered: sqlldr problem

    hi
    I want to insert data into a oracle database table from txt file. for this reason i write sqlldr file
    as
    this file save as pdata1
    LOAD data
    infile 'D:\HRMB\DATALODER\DATA1.txt'
    into table DATACARD
    (cardno position(7:15))

    when i start sql*plus
    I call pdata1 file by following code:

    Host sqlldr hrm/jhd@fsdata pdata1
    then give me error dont get path


    please help me

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Well, don't run SQL*Loader from SQL*Plus prompt. Although you used HOST command, it is not the way to do that.

    Instead, go to operating system command prompt, change working directory to the one which contains control file (basically, for testing purposes you should keep all files in the same directory - it is easier to track loading execution as you'll see LOG file, possible BAD and DISCARD files, ...) and run SQL*Loader from there.

    Error you mentioned: next time, please, use fully qualified Oracle (or operating system) error because it is practically impossible to figure out what might be wrong. "Don't get path" is very ambigously stated and I have no idea WHAT can not be found. Is it a SQLLDR executable? Data file? Control file? Who can tell? Also, it would be a good idea to post the whole session here so that we could SEE what you did.

Posting Permissions

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