Bad file and discard file in sql loader

Here is my data file which has 2 bad records marked in red color. Those records will not match the data type in the table. My control file is as follows. So those filtered records will go to the discard file. Executing the SQL Loader command. Log In. Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action. Click Here to join Tek-Tips and talk with other members! Already a Member? Join your peers on the Internet's largest technical computer professional community.

It's easy to join and it's free. Feel free to ask questions on our Oracle forum. Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. Improve this question. Chepech Chepech 4, 3 3 gold badges 42 42 silver badges 64 64 bronze badges. Add a comment.

Active Oldest Votes. Improve this answer. Andrew Andrew Let me do a quick test and let you know how it went, I'm running it on linux BTW. I never thought on pointing the file to the null device, works like a charm, thanks!