Since the data is sequential in the flat file, you can have SQL*loader load them in order. You'll just need a condition that tells you which table the row of data gets loaded into. In the Oracle Utilities Guide, there is a section titled "Loading records based on a condition."
From here, you should be able to easily load the data
into multiple tables.
This was first published in September 2003