Hi all!

Is it possible to load more than one table from one control file in one sql loader statement. eq.

I got ten fields in my input file (P1 to P10). I got two tables (Table1 and Table2) where I want to load data. Values P1->P5 should go to Table1 and rest of data i.e. P6->P10 should populate in Table2. This should be done in one execution.

Appreciate your view in advance.

abhijit