ORA-01401: inserted value too large for column

[hello99hello]

Hello All,

I am stumped here, and your help would be appreciated.

Here are the sample records I am trying to insert:
201110,MABBOTT-LATE, GERRY,777 634 6363
288867,MAINSCOUGH, LARRY,867 756 7563

Here is the description of my table:
SQL> desc TRANS_PERS_TEMP;
Name Null? Type
--------- -------- ----------------------------
EMPLOYEE_ID NUMBER(6)
LAST_NAME VARCHAR2(30)
FIRST_NAME VARCHAR2(30)
PHONE NUMBER(12)

Here is my sample controll file:
LOAD DATA
TRUNCATE
INTO TABLE TRANS_PERS_TEMP
FIELDS TERMINATED BY ","
(
EMPLOYEE_ID POSITION(01:06)
, LAST_NAME POSITION(07:38)
, FIRST_NAME POSITION(39:69)
, PHONE POSITION(70:82)
)

Here is the sample of my ERror in the log file:

Column Name Position Len Term Encl Datatype
- ---------- ----- ---- ---- ---------------------
EMPLOYEE_ID 1:6 6 , CHARACTER
LAST_NAME 7:38 32 , CHARACTER
FIRST_NAME 39:69 31 , CHARACTER
PHONE 70:82 13 , CHARACTER

Record 1: Rejected - Error on table TRANS_PERS_TEMP, column LAST_NAME.
ORA-01401: inserted value too large for column

Record 2: Rejected - Error on table TRANS_PERS_TEMP, column LAST_NAME.
ORA-01401: inserted value too large for column

Can anyone Help

 

[LKBrwnDBA]

Here are the sample records I am trying to insert:
201110,MABBOTT-LATE, GERRY,777 634 6363
288867,MAINSCOUGH, LARRY,867 756 7563

The above looks like a CSV (Comma separated values) file and you have a wrongly coded control file for a fixed-length record file:

LOAD DATA
TRUNCATE
INTO TABLE TRANS_PERS_TEMP
FIELDS TERMINATED BY ","
(
EMPLOYEE_ID POSITION(01:06)
, LAST_NAME POSITION(07:38)
, FIRST_NAME POSITION(39:69)
, PHONE POSITION(70:82)
)

Use this control file:

LOAD DATA
TRUNCATE
INTO TABLE TRANS_PERS_TEMP
FIELDS TERMINATED BY "," TRAILING NULLCOLS
(
  EMPLOYEE_ID
, LAST_NAME
, FIRST_NAME
, PHONE
)

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb