DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: sql *Loader

  1. #1
    Join Date
    Oct 2000
    Posts
    211
    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

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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!


  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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
  •  


Click Here to Expand Forum to Full Width