I need to load data into an oracle DB using SQLLDR, but I need to pull parts of my ta开发者_如何学编程ble from two different INFILES using the different positions from those infiles?
You can certainly load data from multiple files into a single table and write control files to do that. The format of files should be same. Still running two separate jobs would be a better option. Doing little bit research would help. I have done many extra things using SQL*LOADER.
Sounds like two separate jobs would be simplest.
Depending on the file definitions, it may be possible to use a single job. See this for an idea (except you'd actually have the two record formats loading into the same table rather than different tables).
精彩评论