sql loader question

[tron]

it has been a while so apologies for being rusty...say i want to load some data into a table via sql loader, however if later on i want to add more data (say another record that has a primary key that is already in the table), would sql loader just write to the error log and stop or would it continue to load the data and omit the duplicate key.

[danisha]

all the records wich are in violation will be discarded and put in .bad file

[tron]

will the remaining data from the file be loaded or will it stop at that record and not load any more data? also, is this a normal task or bad practice? i.e. should more checks be done before sqlldr is even called? thanks for the reply.

[kmesser]

You can specify the number of errors to ignore:

ERRORS=100000000

The default is 50

Until that number of errors is encountered, processing will continue, with good records loaded, and bad into *.bad file.