I have two versions of data (in a flat file) to be loaded, ver1 at the beginning of the file and ver2 of the data concatenated at the end. I am using parallel option. Is there a way that I can control SQLloader to load ver1 of the data first and ver2 last?
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.
Dig deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.