Problem solve Get help with specific problems with your technologies, process and projects.

Ordering data loads

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.

This was last published in September 2003

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.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.