Hi ,

How to load Data from two .Dat files using SQL*LOADER ? please give some example coding ..

thanks
thudi

The simple solution I can think of is, write a shell script and invoke two SQL*Loader programs from that shell script.

-Reddi

Hi,

Such scenarios can be easily handled by utl_file, instead of SQL*Loader. Or, you can concatenate the two files and then use a single sql*loader script. with one sql*loader script, i guess its not possible to pull out data from more than one data file.

Thanks,
Prakash

Hi,

There are options to use more than one INFILE clauses used in .ctl file, with space delimeter.
Let me know..

Thanks,
Prakash

Hi,

Yes I seem to recall that it is possible to specify more than one DATAFILE statements in a ctl file - don’t have any examples to hand unfortunately but am sure there will be some on the net and/or Metalink.

Regards, Mark.

if the two files have to load the data to same table then using a shell script first concatenate both the files and then call sql ldr to load the data