问个external table field definition的问题 - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

问个external table field definition的问题

问个external table field definition的问题# Database - 数据库

c*t2010-04-13 07:04

1 楼

Oracle_Loader Access Driver定义：field_definitions的确省长度是255.怎么加大
这个ｍａｘｉｍｕｍ　ｌｅｎｇｔｈ呢？

v*r2010-04-13 07:04

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*t2010-04-13 07:04

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*r2010-04-13 07:04

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*t2010-04-13 07:04

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*r2010-04-13 07:04

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.