Can I specify multiple ctl files in the infile clause of sqlloader.
I have 100s of files loading into one table. Is there an easy option to deal
with this situation.
Dunno about multiple control files but you can speed up inserts by using SQL loader direct path loading. By setting the unrecoverable option redo will not be generated therefore loading is faster. Don't forget to backup first.
Multiple ctl files
If you are using a unix box you can cat your files into one large file.
> cat file1 file2 ....file# > file_to_load
You then can use one sqlloader ctl file.
On NT you could also load all your data into a single DAT file and insert, append all the data from that one DAT file.
Click Here to Expand Forum to Full Width