This content has been marked as final. Show 2 replies
890563 wrote:1) If these files have all the same format, create an external table .
I get new csv files every day loaded to a location. I am trying to write a SQL loader script to read those file on a daily basis and load the data to a table. How can I write the code for this to check the new files that are found in a location and read them from sqlloader
2) Have a OS script that detects which are the latest files and insert the names into a temp table
3) Query the name(s) from temp table and "alter" the location in the external table
4) Load the data from external table into the real table.
5) Remove the file name from the temp table.
can you provide the Filenameing convention.Dialy how it is creating which name?
it is easy way to load the external data into table using external table..