I need to load data from flat files in to my Oracle tables. Once I load data from the flat files, every day I get a flatfile/table (with the same name). That new flat file contains just inserts and updates. Now if i use sql loader again, then then the Inserts will be inserted into the tables, but, since the updates will have the same aprimary key as the ones in the oarcle table, sql loader throws an error saying "primary key violation". The fix is to load the new data into an external table first and use the merge clause and load it into the oracle table.
But, my question is .... can I do this directly using merge clause with sql loader?
Thanks in advance!