c**t
发帖数: 2744 | 1 Oracle_Loader Access Driver定义：field_definitions的确省长度是255.怎么加大
这个ｍａｘｉｍｕｍ ｌｅｎｇｔｈ呢？ |
v*****r
发帖数: 1119 | 2 To override 确省maximum length, you just need to explicitly define the non-
default maximum length in your external table/columns declaration, like : <
column_name> CHAR (1000)) |
c**t
发帖数: 2744 | 3 I defined my column varchar2(500), however the log shows:
actual: 144; maximum: 100
<
【在 v*****r 的大作中提到】
: To override 确省maximum length, you just need to explicitly define the non-
: default maximum length in your external table/columns declaration, like : <
: column_name> CHAR (1000))
|
v*****r
发帖数: 1119 | 4 这个 error 是不是你 load external table data 到 regular table 时产生的？
可能 the rejected row in external table actually has 144 characters in
length, but column in regular table being updated is defined as VARCHAR2(100
). |
c**t
发帖数: 2744 | 5 Some row are extremely long (>32K), which is over block limit.. my solution
is to use clob for some field.
100
【在 v*****r 的大作中提到】
: 这个 error 是不是你 load external table data 到 regular table 时产生的？
: 可能 the rejected row in external table actually has 144 characters in
: length, but column in regular table being updated is defined as VARCHAR2(100
: ).
|
v*****r
发帖数: 1119 | 6 check the target regular table columns definition with the external table
columns/fields definition. Make sure the load source (external table)
columns length are the same or less than the load target table columns
definition.
The error you got is saying one field in the rejected row in external table
is larger than the corresponding column in the target regular table. |
