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?

Daniel Haviv · Accepted Answer · 2012-01-16 22:58:13Z

2

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

answered Jan 16, 2012 at 22:58

Daniel Haviv

1,0361 gold badge8 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Bhushan Over a year ago

Thank you so much sir. Can you please elaborate on "run 3 instances of sqlldr concurrently" with an example. Thanks a ton!

Daniel Haviv Over a year ago

You just open three different cmd windows and run in each of them a different sqlldr

Cofad · Accepted Answer · 2020-05-20 18:28:06Z

0

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.

answered May 20, 2020 at 18:28

Cofad

1841 silver badge7 bronze badges

Comments

Alex · Accepted Answer · 2021-12-22 01:19:05Z

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, 2021 at 1:19

answered Dec 21, 2021 at 23:24

Alex

311 gold badge1 silver badge7 bronze badges

Collectives™ on Stack Overflow

Can I execute multiple control files by one command?

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related