Home » RDBMS Server » Server Utilities » ORA-12899 Error (Oracle)
ORA-12899 Error [message #679816] Wed, 01 April 2020 10:22 Go to next message
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 Go to previous message
Littlefoot
Messages: 21580
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What is the target table description? Columns & datatypes?
Previous Topic: Oracle 12c expdp using external table when it should be using direct
Next Topic: SQL LOADER in shell script
Goto Forum:
  


Current Time: Thu Aug 13 19:16:10 CDT 2020