Can I execute multiple control files by one command?

Question

I have following 3 control files which I have to execute on my DB server-

X.ctl
Y.ctl
Z.ctl

I know the command to execute them one by one which is as follows -

sqlldr PP_DBUSER/PP_DBUSER control=X.ctl log=X.log

However, can anybody tell me if it is possible to execute all the 3 files with one command?

score 2 · Accepted Answer · answered Jan 16 '12 at 22:58

2

No sir, You cannot.
But you can run 3 instances of sqlldr concurrently, each with a diffrent control file.

answered Jan 16 '12 at 22:58

Daniel Haviv

1,036
8
16

Thank you so much sir. Can you please elaborate on "run 3 instances of sqlldr concurrently" with an example. Thanks a ton! – Bhushan Jan 17 '12 at 00:06
You just open three different cmd windows and run in each of them a different sqlldr – Daniel Haviv Jan 17 '12 at 00:35

score 0 · Answer 2 · answered May 20 '20 at 18:28

I believe @Daniel is correct and you cannot execute multiple .ctl files with a single sqlldr command; however, you can put multiple sqlldr commands in one batch/script file and run a single command to execute. This works well if this will need to be repeated multiple times.

Alex · Answer 3 · 2021-12-22T01:19:05.043

0

Execute in CMD:

for %i in (*.ctl) do sqlldr user/pass@tns control=%~ni.ctl log=%~ni.log

or

for %%i in (*.ctl) do sqlldr user/pass@tns control=%%~ni.ctl log=%%~ni.log

edited Dec 22 '21 at 01:19

answered Dec 21 '21 at 23:24

Alex

31
1
1
7

Can I execute multiple control files by one command?

3 Answers3