How to load all the records to multiple tables using sql loader ?
I have x records in a file. I want load all the x records to two tables.
Pl elaborate on which part of the documentation you are having trouble with
SQL*Loader Control File Reference
Switch to external tables and then use multi table insert http://www.oracle-base.com/articles/9i/sql-new-features-9i.php#MultitableInserts