Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SQL Ldr -Load from multiple files to multiple tables in single control file

sathya_mounikaMay 31 2013 — edited May 31 2013
Hi,

Is it possible to load data from mutiple flat files to multiple tables using one control file in SQL Loader? The flat file to database table relation is 1:1. All the data from one flat file goes to one table in the database.

I have around 10 flat files (huge volume) here that need to be loaded into 10 differnt tables. And this needs to be done on a daily basis. Can I start the load in all 10 tables in parallel and from one control file? Should I be pursuing a different approach.

Thanks
Sathya
This post has been answered by Brian Bontrager on May 31 2013
Jump to Answer

Comments

Brian Bontrager
If you want to load several tables at once in parallel, keep them as separate control files. sqlldr loads one thing at a time, but you can have multiple sqlldr processes running at once.

You can load from multiple files in a single control file only if the file layout is the same in each.
http://docs.oracle.com/cd/B19306_01/server.102/b14215/ldr_control_file.htm#i1008015
1 person found this helpful
sathya_mounika
Is there a better way to run mutiple sql loader processes at once than to open multiple command prompts? As said above, i will have to load 10 files into 10 different tables daily. Which means I have to manually run 10 sql loader processes daily manually.

Thanks
Brian Bontrager
Answer
Which operating system? ("Command Prompt" sounds like Windows)

UNIX/Linux: a shell script with multiple calls to sqlldr run in the background with "&" (and possibly nohup)

Windows: A batch file using "start" to launch multiple copies of sqlldr.
http://www.pctools.com/forum/showthread.php?42285-background-a-process-in-batch-%28W2K%29
http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/start.mspx?mfr=true

Edited by: Brian Bontrager on May 31, 2013 4:04 PM
Marked as Answer by sathya_mounika · Sep 27 2020
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 28 2013
Added on May 31 2013
#11g, #database-key-features, #export-import-sql-loader-external-tables, #file, #import, #load, #sql, #table
3 comments
2,643 views