Search code examples
sqloraclesql-loader

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?

Solution

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