Google
Information Storage and Retrieval: Oracle BULK Loader

Pages

Wednesday, May 12, 2010

Oracle BULK Loader

SQL *Loader (sqlldr) is a bulk loader utility to load data from external files into Oracle database. To use this utility, a control file is required which specifies how data should be loaded into the database and a data file is required which specifies what data should be loaded.  A sample control file is as follows:

LOAD DATA
INFILE "datafile"
APPEND INTO TABLE "tablename"
FIELDS TERMINATED BY "separater"
("list of all attribute names to be loaded")
 
A sample data file can be of following form:
 
1,'Gaurav'
2, 'ABC'
3,'PQR'



No comments: