I have created a cron job to run sqlldr in a ksh script against text
flat files on a daily basis. It runs in a loop because on any given day
there may be more than one file to process. Initially I was thinking
that the table it loads into should be truncated prior to the data load
because just in case there were duplicate records loaded. However, after
thinking about it I think that there is a potential to lose data. Is
there a way within sqlldr to delete any duplicates found during the load
in the table? The control file I am using currently does an append into
the table.



Oracle LazyDBA home page