Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> SQLLOAD question
I have a table with > 1M records. Several time a day I insert new
records from an update file using SQLLOAD. Many of the new records have
the same primary key as exists in the table and therefore fail due to
constraints.
I would like to take the "BAD" file from the SQLLOAD and delete those
records from the table with matching keys and then insert the records
from the "BAD" file. How could this be done? The update file contains
from a few hundred records to 5k max.
Thanks,
Bob
Received on Tue Aug 10 1999 - 14:55:29 CDT