SQL Loader - ERROR - Field in data file exceeds maximum length

[balajiyes]

Hi,

I am getting the following error:
Record 47: Rejected - Error on table MMSC_TMP, column RECORD_NR.
Field in data file exceeds maximum length

This my table MMSC_TMP
Column is RECORD_NR Column datatype is NUMBER of 10

This is my control file (first 5 columns)

EDW_MMSC_ID SEQUENCE(MAX,1) ,
SOURCE_SYSTEM_ID CONSTANT '016' ,
RECORD_NR INTEGER EXTERNAL,
NODE_ID CHAR,
MMSC_ENTITY CHAR,

When I check the internet they asked to add CHAR(4000).


Now I am struck with the syntax. Dont know how to add this CHAR(4000)
RECORD_NR INTEGER EXTERNAL,

revert please

Many thanks

[LKBrwn_DBA]

In the controlfile, you need to list first the physical fields in the order in which they appear in the file. Afterwards, list the sequences and constants; for example:

RECORD_NR INTEGER EXTERNAL,
NODE_ID CHAR,
MMSC_ENTITY CHAR, 
...etc...(to last field in file record),
EDW_MMSC_ID SEQUENCE(MAX,1) ,
SOURCE_SYSTEM_ID CONSTANT '016' )