| Error: Field in data file exceeds maximum length [message #69272] |
Sun, 02 December 2001 11:02  |
Karen_merely34
Messages: 1
Registered: December 2001
|
Junior Member |
|
|
HI!
I am getting a "Field in data file exceeds maximum length" error when I use sqlload to load a data file into a newly created table. When I created the table, I specified the data type of this field--feedback to be a VARCHAR2 (1000). Although I only have less than 255 characters of data in this field, sqlload returns this error message. I have no idea why.
Thank you very much for your assistance.
Sincerely
Karen Merely
----------------------------------------------------------------------
|
|
|
|
|
|
| Re: Error: Field in data file exceeds maximum length [message #69284 is a reply to message #69272] |
Mon, 03 December 2001 12:05  |
Prabha R
Messages: 21
Registered: October 2001
|
Junior Member |
|
|
Hi,
I'm also facing exactly the same problem. My data is upto 500 characters. In such cases, how will i load the data using SQL Loader. Is there any other way to overcome this problem. Your suggestions will be greatly appreciated.
----------------------------------------------------------------------
|
|
|
|
| Re: Error: Field in data file exceeds maximum length [message #69293 is a reply to message #69272] |
Tue, 04 December 2001 23:12 |
Ifigenia
Messages: 6
Registered: November 2001
|
Junior Member |
|
|
Overload this default in order for loader to allow longer values.
e.g.
INFILE file
INSERT
INTO TABLE table_name
FIELDS TERMINATED BY ','
(column_1,column_2,column_3 char(500),column_5,..., column_n)
I hope this helps
Ifigenia
----------------------------------------------------------------------
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
