| Resolving Field in data file exceeds maximum length error [message #151198] |
Tue, 13 December 2005 13:15 |
sikyala
Messages: 33
Registered: May 2005
|
Member |
|
|
I am trying to load data from a text file into an Oracle table using sqlldr. Here is my control file:
LOAD DATA
INFILE 'c:\DACS\seb_extract_part1.txt'
INTO TABLE DACS
FIELDS TERMINATED BY '|'
TRAILING NULLCOLS
(IAC_REPORT_ID char(20),
CATEGORY char (70),
AD_ID char (4000),
DATE_0F_PUB char (255),
TITLE char (2000),
ABSTRACT char(4000),KEYWORDS char (4000),
AUTHOR char (4000),
CORPORATE_AUTHOR char (4000),
PUBLISHER char (255),
ORG_PERFORMING char (4000),
CONTRACT_GRANT_ID char (255),
SUPPLEMENTARY_NOTE char (4000),
EXTRA_TEXT_FIELD1 char (255),
EXTRA_TEXT_FIELD2 char (255),
EXTRA_TEXT_FIELD3 char (255))
I used this control file to load the data and a large number of records were rejected because 1 field contains more characters than the maximum size of 4000 characters (the field in question is in red).
What I would like to do is create an additional field (i.e. abstract2 and load the remaining data in that field.
Is that possible? If not what are my options because I need all records loaded into the Oracle table?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
