Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2011

    Question Unanswered: How to send the records having extra columns to the discard file?

    My source file is delimited file, i want to load the data to table using sqlldr. consider one of my records in source is having extra column because of the additional delimiter which is mistakenly added. How to ignore this record?

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    >How to ignore this record?
    specify both "bad" & "discard" files on command line
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2011

    Specifyin bad n discard files...

    All my columns are of varchar2 type, In this case its not ignoring the record instead it ignores the column at the last and loadin.

Posting Permissions

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