Sql Loader

[tansdot]

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.

Thanks

[drain surgeon]

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.

[tycho]

Hi Tansdot,

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.

Greetings Tycho

[drain surgeon]

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.