Results 1 to 3 of 3

Thread: sqlloader error

  1. #1
    Join Date
    Oct 2002
    Posts
    78

    Unanswered: sqlloader error

    Hai
    I got the below error when load the flat file to database using sqlloader

    Paritial record found at end of datafile

    I follwed the steps as follows

    create table emp1(num number,doc clob)

    m1.txt
    ====
    load infile 'd:\m2.dat'
    append into table emp1 fields terminated by '.'
    (num decimal external,res_file filler char,doc lobfile(res_file) terminated by eof nullif res_file='none')


    m2.dat
    =====
    1,d:\resume.txt,


    c:\sqlldr scott/tiger control=d:\m1.txt

    Paritial record found at end of datafile


    Thanks in advance
    mohan

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    fields terminated by a period '.' or a comma ','?

    You have fields terminated by a period
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Is it possible that you have "garbage" characters at the end of the
    datafile itself ... ie; extra spaces, extra linefeeds ... etc...

    Gregg

Posting Permissions

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