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

Thread: SQL Loader Rejects

  1. #1
    Join Date
    Aug 2002
    Posts
    1

    Smile

    Hi,

    I'm using SQLLoader to insert the data in Oracle. Some times it is skipping the first record. Suppose that there are 10 files we are loading in... on some days it loads the data fine and sometimes in some files it skips the first record. Can i know the reason behind this ?

    Thanks
    Ramesh

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    sqlldr will tell you the reason it rejects the record with an error in the log file. The record that gets rejected will get thrown to the file specified by the discard= flag.
    Jeff Hunter

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