Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Can I execute multiple control files by one command?

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

  1. X.ctl
  2. Y.ctl
  3. 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?

like image 338
Bhushan Avatar asked Sep 12 '26 06:09

Bhushan


1 Answers

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

like image 110
Daniel Haviv Avatar answered Sep 13 '26 19:09

Daniel Haviv