Dynamic SQL-Loader control file

Question

I have 20 tables that are temp-tables where we load and validate data constantly and I have a control file for each table.

How can I have a unique control file that just changes the table the data is loaded into? Any suggestion?

Thanks in advance!

---Oracle info---

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi

Answer 1

Suggest you write your control file load the data into a synonym rather than into the specific table. Begin each load run by redefining the synonym to the table you want.

Answer 2

Maybe you can use multiple INTO TABLE clauses, and distinguish bitween them, somehow, with the WHEN clause.
Look here for more details