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.
Try this link
you can specify a different load for each table all in one file.