Thanks! We'll email you
when relevant content is
added and updated.
We are running DB Loader as it's checking every two hrs and if it's gets new file then it's running to load data as the procedure is in JAVA but i am planning to use External tables in Oracle 9i but my question is that How can I manage flat file to load using external tables as we are getting file every two hrs with timestamp?
example: emp_102904.txt is the first file then I am going to get same file as emp_102904_1400.txt then after 2 hrs might be a emp_102904_1600.txt, Is it i need to recreate every time my external tables?
Thanks in advance for any kind of help!
October 30, 2004 1:04 AM
November 4, 2004 8:23 AM