Carete your own cfile using the following example.


LOAD data
INFILE '<<.csv file name>>'
INTO TABLE <> FIELDS TERMINATED BY '|'
(col1 ,col2,col3)

This is just an examle. Your .csv file should be "," separated I guess. so, use the TERMINATED BY ',' clause. And change others fileds according to your table structure.


and the things I given in my prevous post point to the sql*loader documentation.