Question: what is the difference between sql loader and external table in oracle?
Answer: If there are multiple primary input data files with SQL*Loader loads, then a bad file and a discard file are created for each input data file. With external table loads, there is only one bad file and one discard file for all input data files.