How can I manage flat file to load using external tables as we are getting file every two hrs with timestamp?

0 pts.
Tags:
DataCenter
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!
ASKED: October 30, 2004  1:04 AM
UPDATED: November 4, 2004  8:23 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

In order to provide high releability to your data it’s better to recreate the external files.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following