Hi i m using SQLLDR for loading data fgrom text files seperated by pipe '|' character and if the data in text file happens to be such that in the first line the value for the first column is missing then that row gets discard immaterial what ever way u try it out but it works for fine for any other line except one

Eg.

datafile

|Makeroom|34534|Mike (Gets Discarded)
Chi|Makeroom|34534|Mike (Gets Loaded)
|Makeroom|34534|Mike (Gets Loaded)
Chi|Makeroom|34534|Mike (Gets Loaded)

Why only first line gets discarded

Regards
Irfan Khan