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 email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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.