Please send your Questions & Answers or Feedback to "dvmadhavreddy@javabook.org"

Please send your Questions & Answers or Feedback to "mohan@javabook.org"

SQL Loader


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.

Related Posts Plugin for WordPress, Blogger...

Flag Counter