I Want to import dat file in to oracle using sqlldr application. I have written control file to import data. The following is hte control file code I have written
into table DUCT_SECTION
FIELDS TERMINATED BY ','
with this I am not getting any error but the data is not importing into the table. (the table is empty only this your information)
Can anybody explain me the problem? thanks in advance
You might try to include .BAD file and .EXC (bad and exclude) files
in your control file, change the number of errors to a SMALLER number
(say 50 or so), rerun SQLLOADER and then you will have something
that you can look at and determine where the problem is. Then
post results here.