SQL loader is a utility given by oracle to load the data from flat files into oracle database.
SQL loader can load fixed length, separated by comma, delimited by special charecters etc.
.csv --> comma separated value.
Datafile contains the actual data.
Controlfile has to be created by the DBA.
Controlfile describes how the data is in datafile & into which tables sqlloader has to load.
Log file shows the progress of the loading activity and it also contains error messages.
Discard file contains the records that are discarded.
