How to skip the header and trailer records

How to skip the header and trailer records

 

  

Hi All

I have a file from which I need to load the data of it into a d/b table.
The file is having header, detail and trailer records. I only want to load
the detail records and discard the header and trailor. Currently when I am
loading it then it is creating a .bad file for these header and trailor
records.Can anyone help me in this regard as ia am new with sql loader.
Thanks in advance.

With best regards.
Sudipta

Oracle LazyDBA home page