| Getting Field in data file exceeds maximum length when using sqlldr [message #439352] |
Fri, 15 January 2010 14:24  |
ole2009
Messages: 12
Registered: May 2009
|
Junior Member |
|
|
Hi,
I try to upload a table that has a column with varchar2(4000).
In the control file, I specify the column size as char(4000) and I try to use substr function to restrict the data size.
However, I still get 'Field in data file exceeds maximum length' when the data size is more than 4000. It looks like Oracle validate the data size before executing substr function. Any work around there to upload this kind of data if the data size is large than the size defined in control file?
Thanks for your help,
Here is the control file:
LOAD DATA
APPEND
INTO TABLE big_table
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
trailing nullcols
(
col1,
col2 char(4000) "substr(:col2,1, 4000)"
)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
