SQL*LOADER issue

[prince_jr]

Try this -
OPTIONS (BINDSIZE=1024000)
LOAD DATA
INFILE * -----> specify the textfile along with path
INTO TABLE air_miles
REPLACE
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(
Col1 number(10) nullif col1=blanks,---->specify the datatypes for all columns along with width you have created the table.
col2 char(20) nullif col2=blanks,
col3 date(14) "MMDDYYYY" nullif col3=blanks
)
NOTE: Do not specify nullif (columnname)=blanks if the column is primary or foreign or not null columns.
Let me know if this helps.