-
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 [url]http://technet.oracle.com[/url] 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
Thanx
Sam
Life is a journey, not a destination!
-
A similar issue came up the other day, see [url]http://www.dbasupport.com/forums/showthread.php?threadid=5926[/url]
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|