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

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,626 views