Today's Messages (on)  | Unanswered Messages (off)

Forum: Server Utilities
 Topic: ORA-12899 Error
ORA-12899 Error [message #679816] Wed, 01 April 2020 10:22
chaitanyasrigakollu
Messages: 1
Registered: April 2020
Junior Member
Hi All,

I'm trying to load MainFrames based flat file into our oracle table using sql loader.. But i'm getting the error ORA 12899 - value too large for column ...
And my control file looks like below

OPTIONS (SILENT=(FEEDBACK),ERRORS=999999999, ROWS=5000, PARALLEL=TRUE)
LOAD DATA
CHARACTERSET WE8EBCDIC500
INFILE NCT_UHC_CL_ENMHDR_W_20190803_080101.DAT "FIX 5262"
REPLACE
INTO TABLE TABLE A
TRAILING NULLCOLS
(
C_HDR_ID_CD_HDR POSITION(1:2)
,C_CLM_CAT_CD_HDR POSITION(3:3)
,C_TCN_NUM_HDR POSITION(4:19)
)

Though we are loading the file on a positional based, we are still receiving an above error..

Could anyone please help me with the solution.

Thanks,
Chaitanya
Re: ORA-12899 Error [message #679817 is a reply to message #679816] Wed, 01 April 2020 13:22
Littlefoot
Messages: 21548
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What is the target table description? Columns & datatypes?



Current Time: Wed Apr 01 15:49:22 CDT 2020