DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: sqlldr error

  1. #1
    Join Date
    Feb 2001
    Posts
    23
    hi

    i'm having problem using sqlldr
    here's what i did that gives me error >PARTIAL RECORD FOUND AT END OF DATAFILE<

    load data
    infile 'user.txt'
    append
    into table users
    fields terminated by "|" trailing nullcols
    (acctid, password)

    C>sqqldr userid=uid/pwd,control=name of ctl

    can anyone help me what's wrong and how can i load data to oracle table <NT>

    thanks guys 4 help

  2. #2
    Join Date
    Feb 2001
    Posts
    83
    Hi,

    Make sure the last record in the datafile is complete and has the correct terminating character(s). Also, if fixed-length records are in use, verify that no record exceeds the platform-specific length for a single record.
    with regards
    Prasanna S

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