Here is an example of my logfile that it is generated:
SQL*Loader: Release 8.1.6.0.0 - Production on Mon Apr 8 10:06:31 2002 (c) Copyright 1999 Oracle Corporation. All rights reserved. Control File: app_dev.testcaseuatstatus.ctl Data File: app_dev.testcaseuatstatus.dat Bad File: app_dev.testcaseuatstatus.bad Discard File: none specified (Allow all discards) Number to load: ALL Number to skip: 0 Errors allowed: 50 Bind array: 64 rows, maximum of 65536 bytes Continuation: none specified Path used: Conventional Table APP_DEV.TESTCASEUATSTATUS, loaded from every logical record. Insert option in effect for this table: INSERT TRAILING NULLCOLS option in effect Column Name Position Len Term Encl Datatype ------------------------------ ---------- ----- ---- ---- ------------------ --- TESTCASESTATUSID FIRST 4 INTEGER TESTCASEID NEXT 4 INTEGER USERID NEXT 4 INTEGER CORDID NEXT 4 INTEGER UATASSIGNED NEXT 4 INTEGER PASSFAILSTATUSID NEXT 4 INTEGER DATETESTED NEXT * , " CHARACTER SQL string for column : "to_date(:DateTested,'mm/dd/yyyy hh:mi:ss pm')" TASKID NEXT 4 INTEGER RETEST NEXT 4 INTEGER ASSID NEXT 4 INTEGER NONVALID NEXT 4 INTEGER Record 1: Rejected - Error on table APP_DEV.TESTCASEUATSTATUS, column DATETESTED. Initial enclosure character not found Record 2: Rejected - Error on table APP_DEV.TESTCASEUATSTATUS, column DATETESTED. Initial enclosure character not found Record 3: Rejected - Error on table APP_DEV.TESTCASEUATSTATUS, column DATETESTED. Initial enclosure character not found Record 4: Rejected - Error on table APP_DEV.TESTCASEUATSTATUS, column DATETESTED. Initial enclosure character not found Record 5: Rejected - Error on table APP_DEV.TESTCASEUATSTATUS, column DATETESTED. Initial enclosure character not found Table APP_DEV.TESTCASEUATSTATUS: 0 Rows successfully loaded. 5 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: 19072 bytes(64 rows) Space allocated for memory besides bind array: 0 bytes Total logical records skipped: 0 Total logical records read: 5 Total logical records rejected: 5 Total logical records discarded: 0 Run began on Mon Apr 08 10:06:31 2002 Run ended on Mon Apr 08 10:06:36 2002 Elapsed time was: 00:00:05.96 CPU time was: 00:00:03.92 thanks alot, David Ehresmann. > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of John Hallas > Sent: Monday, April 08, 2002 12:10 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: SQL*Loader > > > David, > What does your log file show as the reason for failure? > John > -----Original Message----- > Sent: 08 April 2002 17:16 > To: Multiple recipients of list ORACLE-L > > I am trying to user SQL*Loader to load some tables in my 8i database. The > data will not load. It seems to have to do with the format. In > particular > the date format. Can anybody help? I have messed with this for 2 days. > > Here is my data file (only 5 rows displayed): > > 80,3614,32,0,1,2,'12/20/2001 2:34:42 PM',1860,0,,0 > 81,3619,32,0,1,1,'12/20/2001 2:38:42 PM',1861,0,,0 > 82,3620,32,0,1,1,'12/20/2001 2:41:37 PM',1861,0,,0 > 83,3621,32,0,1,2,'12/20/2001 2:42:30 PM',1861,0,,0 > 84,3622,32,0,1,2,'12/20/2001 2:42:15 PM',1861,0,,0 > > Here is my control file: > > LOAD DATA > INSERT > INTO TABLE APP_DEV.TESTCASEUATSTATUS > FIELDS TERMINATED BY "," ENCLOSED BY '"' > TRAILING NULLCOLS > (TESTCASESTATUSID INTEGER, > TESTCASEID INTEGER, > USERID INTEGER, > CORDID INTEGER, > UATASSIGNED INTEGER, > PASSFAILSTATUSID INTEGER, > DATETESTED char "to_date(:DateTested,'mm/dd/yyyy hh:mi:ss pm')", > TASKID INTEGER, > RETEST INTEGER, > ASSID INTEGER, > NONVALID INTEGER) > > I have also tried: DATETESTED date 'mm/dd/yyyy hh:mi:ss pm' this string > for the date field. > > > David Ehresmann > Oracle DBA 8i OCP > MCI Worldcom > [EMAIL PROTECTED] > 972.656.1015 > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: David Ehresmann > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: John Hallas > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Ehresmann INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).