| 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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
