-
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
-
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
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
-
DAT 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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|