| Urgent [message #74678] |
Thu, 03 February 2005 05:33  |
DK
Messages: 11
Registered: July 2002
|
Junior Member |
|
|
SQL*Loader Error - Field in data file exceeds maximum length
Hi!
I have a problem with SQL*Loader.
I have a txt file, which I want to import into Oracle row by row using SQL*Loader.
And using this I get the error message:
Rejected - Error on table '***', column '***'.Field in data file exceeds maximum length
What can I do about it?
Oh, by the way, I noticed and overcome some bug in SQL*Loader.
Here is the original file:
LOAD DATA
INFILE 'C:RACUNI.TXT'
INTO TABLE temp
(vrstica)
When I used this control file, the data from the file RACUNI.TXT was imported to table named TEMP in Oracle, but only the first character in each row! That was quite strange... So when I wrote the control file, which is below, the SQL*Loader did the job well. by the way, I don't have the '|*?@ß' separator! I think this is some kind of bug in SQL*Loader.
Here is my Control file:
LOAD DATA
INFILE 'C:RACUNI.TXT'
INTO TABLE temp
FIELDS TERMINATED BY '|*?@ß' OPTIONALLY ENCLOSED BY '|*?@ß'
(vrstica)
Thanks.
With regards,
|
|
|
|
| Re: Urgent [message #74689 is a reply to message #74678] |
Thu, 03 February 2005 22:49  |
Sreedhar Reddy
Messages: 55
Registered: January 2002
|
Member |
|
|
check your text file, whether it contains any characters of *, if the column the varchar type increase the columwidth and check it...with the lod control file.
just ..show the data file which you r importing
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
