Home » RDBMS Server » Server Utilities » running multiple sql loader files at once in windows (merged)
running multiple sql loader files at once in windows (merged) [message #325265] Thu, 05 June 2008 08:18 Go to next message
kris123
Messages: 5
Registered: June 2008
Junior Member
Hi

I have 20 sqlloader ctl files, each ctl files takes one dat afile and loads in to one table. I want to run them in one go, than running each one separately.I am on windows xp platform.Is there any way to do it.


regards
krishna
Re: SQL loader [message #325272 is a reply to message #325265] Thu, 05 June 2008 08:42 Go to previous messageGo to next message
Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India
Senior Member
Quote:
I want to run them in one go, than running each one separately


What do you actually want, dear? Want to run them all togather on one enter press, or each one separately..


Well, you can create batch file script to run all the command at one enter press.

Regards..
Re: SQL loader [message #325308 is a reply to message #325265] Thu, 05 June 2008 12:15 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
Have a look at the documentation for SQL*Loader http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/ldr_concepts.htm#SUTIL003 then. You don't say if you want to load 20 different files into 20 different table, same structure, different structure, same schema, different schema, different database, etc.
running multiple sql loader files at once in windows [message #326381 is a reply to message #325265] Wed, 11 June 2008 05:08 Go to previous messageGo to next message
kris123
Messages: 5
Registered: June 2008
Junior Member

I have a bunch of ctl files .I want to run all of them at once from windows.Is there a way to do it.Each ctl file is loading separate table

sql loader ctl1
sqlloader ctl2
sqlloader ctl3 ;;;etc.

I do not know how to create a windows batch file to run all of them

help is appreciated
Re: running multiple sql loader files at once in windows [message #326383 is a reply to message #326381] Wed, 11 June 2008 05:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Is this not the same question you asked a while ago?

Yes it is:
http://www.orafaq.com/forum/m/325265/102589/#msg_325265

Don't start a new topic for the same question.
If you have new information, update the previous one.

Regards
Michel
Re: running multiple sql loader files at once in windows (merged) [message #326444 is a reply to message #325265] Wed, 11 June 2008 09:27 Go to previous messageGo to next message
kris123
Messages: 5
Registered: June 2008
Junior Member

the question is how to run in a batch file.I am not familiar with writting batch files that will have 20 sqlloader command line statments.If the code is available can you plase share
Re: running multiple sql loader files at once in windows (merged) [message #326453 is a reply to message #326444] Wed, 11 June 2008 09:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Write it as for one line but with several commands.

Regards
Michel
Re: running multiple sql loader files at once in windows (merged) [message #326552 is a reply to message #326444] Wed, 11 June 2008 23:41 Go to previous message
Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India
Senior Member
write all the commands you use to execute the loader files into one file.
Save that file with .cmd exetension.
Then from command prompt, instade of giving all those loader commands one by one, what you need to enter is just that file name. and all the commands inside that file will be executed one after another as if you were entering them manually. Smile

Hope you got the idea about what you need to do..

Regards..
Previous Topic: problem while Importing dmp file
Next Topic: External table selection problem
Goto Forum:
  


Current Time: Tue Dec 24 11:06:05 CST 2024