Printable View
Hi Friends,
I need to load a table using sql*loader, every hour. I get the data in a text format. The data includes some updated data too. Is there a way for the loader to compare the fresh data(in the text file) with the existing data in the table and then load the required data?
Thanks
manjunath
Yes, you can do it through the "WHEN" clause, or you could fire a before insert trigger to do the validation. For more detailes check http://technet.oracle.com and do a search on sql loader. If you are using the when clause, then you would be better off, if your text file is of a fixed field format. Other wise you might have to resolute to the option of firing trigger(s).
Good luck,
Sam
A similar issue came up the other day, see http://www.dbasupport.com/forums/sho...?threadid=5926