Oracle Database Discussions

hi ,
i am sql*loader utility ,i am new to it. Usually i use to import through ms access.i saved the .xls file to .csv.
while importing through sql*loader i am getting error. can anyone help me.

i am giving the details of my control file and log file .

LOAD DATA
INFILE 'D:\DR_DOCUMENTS_UPE_BC_23.csv'
BADFILE 'D:\DR_DOCUMENTS_UPE_BC_23.bad'
DISCARDFILE 'D:\DR_DOCUMENTS_UPE_BC_23.dsc'

INTO TABLE "DRIDEA"."DR_DOCUMENTS"
INSERT
FIELDS TERMINATED BY ','
(ID,
DR_ACKNOWL_INDICATOR,
DR_ADDRESSEE_BA_ID,
DR_ADDRESSEE_BA_PKEY,
DR_ADDRESSEE_CONTRACT_ID,
DR_ADDRESSEE_CONTRACT_PKEY,
DR_ADDRESSEE_CUSTOMER_ID,
DR_ADDRESSEE_CUSTOMER_PKEY,
DR_ASS_DOC_COPY_COPY_IND,
DR_ASS_DOC_CR_DATE_TIMESTAMP,
DR_ASS_DOC_CR_DATE_TIME_OFFSET,
DR_ASS_DOC_CR_TIMEZONE_ID,
DR_ASS_DOC_MN_DATE_TIMESTAMP,
DR_ASS_DOC_MN_DATE_TIME_OFFSET,
DR_ASS_DOC_MN_TIMEZONE_ID,
DR_ASS_DOC_NUMBER_EXTERNAL_ID,
DR_ASS_DOC_NUMBER_INTERNAL_ID,
DR_ASS_DOC_RF_DATE_TIMESTAMP,
DR_ASS_DOC_RF_DATE_TIMEZONE_ID,
DR_ASS_DOC_RF_DATE_TIME_OFFSET,
DR_ASS_DOC_TYPE_ASS_DOC_TYPE,
DR_ASS_DOC_TYPE_BILL_CYCLE,
DR_ASS_DOC_TYPE_BILL_MED_ID,
DR_ASS_DOC_TYPE_BILL_MED_PKEY,
DR_ASS_DOC_TYPE_BILL_PURPOSE,
DR_ASS_DOC_TYPE_GEN_PURPOSE,
DR_ASS_LAST_SEND_DATE_TIMEST,
DR_ASS_LAST_SEND_DATE_TIMEZ_ID,
DR_ASS_LAST_SEND_DATE_TIME_OFF,
DR_ASS_REACT_DATE_TIMESTAMP,
DR_ASS_REACT_DATE_TIMEZONE_ID,
DR_ASS_REACT_DATE_TIME_OFFSET,
DR_DOCU_CREAT_DATE_TIMESTAMP,
DR_DOCU_CREAT_DATE_TIMEZONE_ID,
DR_DOCU_CREAT_DATE_TIME_OFFSET,
DR_DOCU_LINK_LINK,
DR_DOCU_NUMBER_INTERNAL_ID,
DR_DOCU_REFERENCE_LINK_TYPE,
DR_DOCU_TYPE_DOC_FORMAT,
DR_DOCU_TYPE_DOC_TYPE,
DR_DOC_LANGUAGE_LNG_PKEY,
DR_RECORD_PART_ID,
DR_REFERENCE_PART_ID,
DR_REQUEST_ASS_DOC_REQUEST_ID,
DR_REQUEST_BUS_UNIT_ID,
DR_REQUEST_BUS_UNIT_PKEY,
UDS_STREAM_ID)

ny log error is

SQL*Loader: Release 10.2.0.1.0 - Production on Mon Jun 21 10:40:23 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Control File: D:\DR.CTL
Data File: D:\DR_DOCUMENTS_UPE_BC_23.csv
Bad File: D:\DR_DOCUMENTS_UPE_BC_23.bad
Discard File: D:\DR_DOCUMENTS_UPE_BC_23.dsc
(Allow all discards)

Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array: 64 rows, maximum of 256000 bytes
Continuation: none specified
Path used: Conventional

Table "DRIDEA"."DR_DOCUMENTS", loaded from every logical record.
Insert option in effect for this table: INSERT

Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
ID FIRST * , CHARACTER
DR_ACKNOWL_INDICATOR NEXT * , CHARACTER
DR_ADDRESSEE_BA_ID NEXT * , CHARACTER
DR_ADDRESSEE_BA_PKEY NEXT * , CHARACTER
DR_ADDRESSEE_CONTRACT_ID NEXT * , CHARACTER
DR_ADDRESSEE_CONTRACT_PKEY NEXT * , CHARACTER
DR_ADDRESSEE_CUSTOMER_ID NEXT * , CHARACTER
DR_ADDRESSEE_CUSTOMER_PKEY NEXT * , CHARACTER
DR_ASS_DOC_COPY_COPY_IND NEXT * , CHARACTER
DR_ASS_DOC_CR_DATE_TIMESTAMP NEXT * , CHARACTER
DR_ASS_DOC_CR_DATE_TIME_OFFSET NEXT * , CHARACTER
DR_ASS_DOC_CR_TIMEZONE_ID NEXT * , CHARACTER
DR_ASS_DOC_MN_DATE_TIMESTAMP NEXT * , CHARACTER
DR_ASS_DOC_MN_DATE_TIME_OFFSET NEXT * , CHARACTER
DR_ASS_DOC_MN_TIMEZONE_ID NEXT * , CHARACTER
DR_ASS_DOC_NUMBER_EXTERNAL_ID NEXT * , CHARACTER
DR_ASS_DOC_NUMBER_INTERNAL_ID NEXT * , CHARACTER
DR_ASS_DOC_RF_DATE_TIMESTAMP NEXT * , CHARACTER
DR_ASS_DOC_RF_DATE_TIMEZONE_ID NEXT * , CHARACTER
DR_ASS_DOC_RF_DATE_TIME_OFFSET NEXT * , CHARACTER
DR_ASS_DOC_TYPE_ASS_DOC_TYPE NEXT * , CHARACTER
DR_ASS_DOC_TYPE_BILL_CYCLE NEXT * , CHARACTER
DR_ASS_DOC_TYPE_BILL_MED_ID NEXT * , CHARACTER
DR_ASS_DOC_TYPE_BILL_MED_PKEY NEXT * , CHARACTER
DR_ASS_DOC_TYPE_BILL_PURPOSE NEXT * , CHARACTER
DR_ASS_DOC_TYPE_GEN_PURPOSE NEXT * , CHARACTER
DR_ASS_LAST_SEND_DATE_TIMEST NEXT * , CHARACTER
DR_ASS_LAST_SEND_DATE_TIMEZ_ID NEXT * , CHARACTER
DR_ASS_LAST_SEND_DATE_TIME_OFF NEXT * , CHARACTER
DR_ASS_REACT_DATE_TIMESTAMP NEXT * , CHARACTER
DR_ASS_REACT_DATE_TIMEZONE_ID NEXT * , CHARACTER
DR_ASS_REACT_DATE_TIME_OFFSET NEXT * , CHARACTER
DR_DOCU_CREAT_DATE_TIMESTAMP NEXT * , CHARACTER
DR_DOCU_CREAT_DATE_TIMEZONE_ID NEXT * , CHARACTER
DR_DOCU_CREAT_DATE_TIME_OFFSET NEXT * , CHARACTER
DR_DOCU_LINK_LINK NEXT * , CHARACTER
DR_DOCU_NUMBER_INTERNAL_ID NEXT * , CHARACTER
DR_DOCU_REFERENCE_LINK_TYPE NEXT * , CHARACTER
DR_DOCU_TYPE_DOC_FORMAT NEXT * , CHARACTER
DR_DOCU_TYPE_DOC_TYPE NEXT * , CHARACTER
DR_DOC_LANGUAGE_LNG_PKEY NEXT * , CHARACTER
DR_RECORD_PART_ID NEXT * , CHARACTER
DR_REFERENCE_PART_ID NEXT * , CHARACTER
DR_REQUEST_ASS_DOC_REQUEST_ID NEXT * , CHARACTER
DR_REQUEST_BUS_UNIT_ID NEXT * , CHARACTER
DR_REQUEST_BUS_UNIT_PKEY NEXT * , CHARACTER
UDS_STREAM_ID NEXT * , CHARACTER

value used for ROWS parameter changed from 64 to 21
Record 1: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column ID.
Field in data file exceeds maximum length
Record 2: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Field in data file exceeds maximum length
Record 3: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Field in data file exceeds maximum length
Record 4: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 5: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 6: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 7: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 8: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 9: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 10: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 11: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 12: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 13: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 14: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 15: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 16: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 17: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 18: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 19: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 20: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 21: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 22: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 23: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 24: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 25: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 26: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 27: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 28: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 29: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 30: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 31: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 32: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 33: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 34: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 35: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 36: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 37: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 38: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 39: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 40: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 41: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 42: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 43: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 44: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 45: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 46: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 47: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 48: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 49: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 50: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 51: Rejected - Error on table "DRIDEA"."DR_DOCUMENTS", column DR_ACKNOWL_INDICATOR.
Column not found before end of logical record (use TRAILING NULLCOLS)

MAXIMUM ERROR COUNT EXCEEDED - Above statistics reflect partial run.

Table "DRIDEA"."DR_DOCUMENTS":
0 Rows successfully loaded.
51 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.


Space allocated for bind array: 254646 bytes(21 rows)
Read buffer bytes: 1048576

Total logical records skipped: 0
Total logical records read: 51
Total logical records rejected: 51
Total logical records discarded: 0

Run began on Mon Jun 21 10:40:23 2010
Run ended on Mon Jun 21 10:40:23 2010

Elapsed time was: 00:00:00.13
CPU time was: 00:00:00.04


thanks in advance,
kishore.