How to automate SQL*Loader commands

[bsuroop]

Hello Friends,

Please help me how I can automate my sql*loader commands.
I need to export huge data from flat files to oracle database.
It will be in fixed formats and comma delimited.
Manually I can run the control file from the DOS prompt and execute the commands. But I need to automate that process.pls let me also know how I can make a control file generic.

When I want to export 100 tables then I need to create different control files according to that and do the process. Instead how can do it at a single shot.

Pls help me if you can give me any scripts or any methods to follow this

Thanks in Advance,

Kishan.

[rajabalachandra]

for automation you can use OS schedules.

if 100 tables are of different structures
then you have to have 100 control files.