02-07-07, 23:01 #1Registered User
- Join Date
- Jul 2004
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
02-07-07, 23:13 #2Registered User
Provided Answers: 1
- Join Date
- Aug 2003
- Where the Surf Meets the Turf @Del Mar, CA
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.htmYou 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.