Record 1: Rejected - Error on table DP, column SPECIFICATION.
ORA-12899: value too large for column "ROPAT"."DP"."SPECIFICATION" (actual: 23, maximum: 20)

OPTIONS (ERRORS=0,SKIP=0)
load data
 infile *
 into table DP
 fields terminated by "|"
 TRAILING NULLCOLS
 ( SESSIONTYPE, SPECIFICATION)
begindata
Backup|Dro_IDB_Daily_Full_1300|

CREATE TABLE DP
(
  SESSIONTYPE    VARCHAR2(20 CHAR),
  SPECIFICATION  VARCHAR2(20 CHAR)
)
TABLESPACE USERS
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          80K
            NEXT             1M
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;

SQL*Loader: Release 11.2.0.3.0 - Production on Tue Aug 20 10:51:00 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Control File:   sl.txt
Data File:      sl.txt
  Bad File:     sl.bad
  Discard File:  none specified
 
 (Allow all discards)

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

Table DP, 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
------------------------------ ---------- ----- ---- ---- ---------------------
SESSIONTYPE                         FIRST     *   |       CHARACTER            
SPECIFICATION                        NEXT     *   |       CHARACTER            

Record 1: Rejected - Error on table DP, column SPECIFICATION.
ORA-12899: value too large for column "ROPAT"."DP"."SPECIFICATION" (actual: 23, maximum: 20)


MAXIMUM ERROR COUNT EXCEEDED - Above statistics reflect partial run.

Table DP:
  0 Rows successfully loaded.
  1 Row 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:                  33024 bytes(64 rows)
Read   buffer bytes: 1048576

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

Run began on Tue Aug 20 10:51:00 2013
Run ended on Tue Aug 20 10:51:01 2013

Elapsed time was:     00:00:00.18
CPU time was:         00:00:00.06