SQL*Loader: Release 9.2.0.1.0 - Production on Mon Aug 21 09:26:39 2006 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Control File: /web/apps/test/ai/sboa/audit/audit.ldr Data File: /web/testwww/sboa/WebReports/repweb.txt Bad File: /web/apps/test/ai/sboa/audit/repweb.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 256000 bytes Continuation: none specified Path used: Conventional Table AUDIT_REPORT, 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 ------------------------------ ---------- ----- ---- ---- --------------------- RP_NUMBER FIRST * : CHARACTER SQL string for column : "trim(:RP_NUMBER)" UNIT_NAME NEXT * : CHARACTER SQL string for column : "trim(:UNIT_NAME)" COUNTY NEXT * : CHARACTER SQL string for column : "trim(:COUNTY)" BEG_DATE NEXT * : CHARACTER SQL string for column : "to_date(:BEG_DATE, 'YYYYMMDD')" END_DATE NEXT * : CHARACTER SQL string for column : "to_date(:END_DATE, 'YYYYMMDD')" AUDIT_TYPE NEXT * : CHARACTER SQL string for column : "trim(:AUDIT_TYPE)" RP_DESC NEXT * : CHARACTER SQL string for column : "trim(:RP_DESC)" RP_DATE NEXT * : CHARACTER SQL string for column : "to_date(:RP_DATE, 'YYYYMMDD')" Table AUDIT_REPORT: 18035 Rows successfully loaded. 0 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: 132096 bytes(64 rows) Read buffer bytes: 1048576 Total logical records skipped: 0 Total logical records read: 18035 Total logical records rejected: 0 Total logical records discarded: 0 Run began on Mon Aug 21 09:26:39 2006 Run ended on Mon Aug 21 09:26:53 2006 Elapsed time was: 00:00:14.83 CPU time was: 00:00:00.42