DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2001
    Does anybody know of a way of passing parameters (variables) to a SQLLDR control file?

    We will be using SQLLDR to load several sets of tables, and need to load a different identifying code with each row in each table for each set of data.

    The only way of achieving this seems to be to manually edit each .ctl file and set the DataSet identifier as a CONSTANT for each set of data.

    Any help much appreciated.

    Thanks in Advance for your help

  2. #2
    Join Date
    Jan 2001

    Try this link


    you can specify a different load for each table all in one file.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.