Home » RDBMS Server » Server Utilities » How to use Dynamic data file name in SQL*Loader control file? (merged)
How to use Dynamic data file name in SQL*Loader control file? (merged) [message #388813] Thu, 26 February 2009 05:19 Go to next message
gynanda
Messages: 33
Registered: November 2007
Member
Hi all,

I have a requirement to create a control file to insert data into a single table, which runs background everyday. I have created and its working fine. The thing is data file name is not constant. It changes everyday, I mean file name contains YYMMDD_Clients.csv.

Can someone help me to how I can write the control file which dynamic data file name?

Thanks in advance.

Cheers.



Re: How to use Dynamic data file name in SQL*Loader control file? [message #388815 is a reply to message #388813] Thu, 26 February 2009 05:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't put the file name inside the control file put it in the sqlldr command line.

Please post your question in the correct forum.

Regards
Michel
Re: How to use Dynamic data file name in SQL*Loader control file? [message #388837 is a reply to message #388813] Thu, 26 February 2009 06:15 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Same answer.

Regards
Michel
Previous Topic: How to load rejected records in SQLLDR into a table
Next Topic: EXPDP
Goto Forum:
  


Current Time: Fri Dec 09 04:07:43 CST 2016

Total time taken to generate the page: 0.11407 seconds