LOAD DATA
INFILE      'C:\IDB Price List.csv'
BADFILE     'C:\IDB Price List.bad'
DISCARDFILE 'C:\IDB Price List.dsc'
INSERT INTO TABLE idb_price_list 
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS
(group_no,type,description,amt,flag)

create table idb_price_list
(
group_no varchar2(3),
stype varchar2(3),
sdescription varchar2(100),
samt number(5),
sflag varchar2(1)
)

C:\Documents and Settings\Administrator>sqlldr80 userid=ultgnp/test control=C:\test.ctl log=c:\IDB01.log

SQL*Loader: Release 8.1.7.0.0 - Production on Sun Aug 1 10:52:59 2010

(c) Copyright 2001 Oracle Corporation.  All rights reserved.

Commit point reached - logical record count 50
Commit point reached - logical record count 100

Control File:   C:\test.ctl
Data File:      c:\idb01.txt
  Bad File:     C:\idb01.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 IDB_PRICE_LIST, 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
------------------------------ ---------- ----- ---- ---- ---------------------
GROUP_NO                            FIRST     *   ,  O(") CHARACTER            
STYPE                                NEXT     *   ,  O(") CHARACTER            
SDESCRIPTION                         NEXT     *   ,  O(") CHARACTER            
SAMT                                 NEXT     *   ,  O(") CHARACTER            
SFLAG                                NEXT     *   ,  O(") CHARACTER            

Record 1: Rejected - Error on table IDB_PRICE_LIST, column GROUP_NO.
ORA-01722: invalid number
Record 46: Rejected - Error on table IDB_PRICE_LIST, column GROUP_NO.
ORA-01722: invalid number

Record 47: Rejected - Error on table IDB_PRICE_LIST, column GROUP_NO.
ORA-01722: invalid number

Record 48: Rejected - Error on table IDB_PRICE_LIST, column GROUP_NO.
ORA-01722: invalid number

Record 49: Rejected - Error on table IDB_PRICE_LIST, column GROUP_NO.
ORA-01722: invalid number

Record 50: Rejected - Error on table IDB_PRICE_LIST, column GROUP_NO.
ORA-01722: invalid number

Record 51: Rejected - Error on table IDB_PRICE_LIST, column GROUP_NO.
ORA-01722: invalid number


MAXIMUM ERROR COUNT EXCEEDED - Above statistics reflect partial run.

Table IDB_PRICE_LIST:
  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:                  64500 bytes(50 rows)
Space allocated for memory besides bind array:        0 bytes

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

Run began on Sun Aug 01 10:49:34 2010
Run ended on Sun Aug 01 10:49:35 2010

Elapsed time was:     00:00:00.86
CPU time was:         00:00:00.02