-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|