Load data from a flat file to oracle.

Shell Programming and Scripting
1

I have a flat file with records like

Header
123 James Williams Finance2000
124 Pete Pete HR 1500
125 PatrickHeather Engg 3000
Footer

The structure is:
Eno:4 characters
Name:8 characters
Surname : 9 characters
Dept:7 characters
Sal:4characters

These are sample records.Need to load a large data of this format onto Table1.Read somewhere that i can create a XML and and then load it via sqlloader.
Also one important here is I need to load Name,Surname and Dept also in Table2.
means some field might go onto 1 table and the others into other.

Can any one point me in right direction.
Thanks

2

You can load via the SQL loader, no need to go for the creation of XML and all . Google it i hope there are so many links on "how to load data into oracle using sqlldr".