I need to load some remote data files into my Oracle 11g database. The files are fixed length files and they are not huge, less than 5 MB.
I've explored using SQL*Loader and I think this is a good fit. I would prefer External tables, but the files are remote and as I understand, External Tables as well as stored procedures, require local access to the data files.
The next problem is automating the loads. Files will show up throughout the day on a remote server and I need some process that: 1) detects the data file transfers are complete and 2) kicks off my SQL*Loader job. The remote server (where the data files will land) is a Windows 2008 server.
Any thoughts and assistance is much appreciated. Thank you.