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...
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
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.