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.

Report message to a moderator

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: 68647
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

Report message to a moderator

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: 68647
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Same answer.

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Apr 29 03:50:15 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.