How can I manage flat file to load using external tables as we are getting file every two hrs with timestamp?
Hi,
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!
Software/Hardware used:
Software/Hardware used:
ASKED:
October 30, 2004 1:04 AM
UPDATED:
November 4, 2004 8:23 AM
Answer Wiki:
In order to provide high releability to your data it's better to recreate the external files.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
