Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004
    Posts
    62

    Unanswered: How to avoid errors or ignore errors during LOAD DATA INFILE / sqlldr

    I have a table with unique keys. I have a flat file that has duplicates records and i want to load it into my unique table.
    The problems was , after 100 records of violating unique keys i cannot load any data.
    How to ignore unique keys or how to manipulate sqlldr to ignore these unique keys errors.

    In MySQL i can simply use
    LOAD DATA INFILE IGNORE into TABLE <mytable> that it will ignore unique keys and continue the next records

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    ERRORS specifies the maximum number of insert errors to allow. If the number of errors exceeds the value specified for ERRORS, then SQL*Loader terminates the load. To permit no errors at all, set ERRORS=0.

    To specify that all errors be allowed, use a very high number.

    If you get really desperate, you can just read the fine Utilities Manual to find your own answers next time
    http://download-west.oracle.com/docs...b14215/toc.htm
    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.

Posting Permissions

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