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.
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.