SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get Dynamic data file in SQL*Loader?

587040Feb 26 2009 — edited Feb 26 2009

Hi all,

I have a requirement that needs to import data everyday using background process. I have created a control file with the fixed datafile name and calling it through java. It is working fine.

The thing is data file name is not constant, it changes everyday (I mean the file name format is YearMonthDate_Clients.cvs). But the the data file location is fixed location.

How can I get the data file name dynamically?

Can someone has the answer?

Thanks in advance,
Kalyogi

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 26 2009

Added on Feb 26 2009

6 comments

350 views