问个external table field definition的问题# Database - 数据库
c*t
1 楼
Oracle_Loader Access Driver定义：field_definitions的确省长度是255.怎么加大
这个ｍａｘｉｍｕｍ ｌｅｎｇｔｈ呢？
这个ｍａｘｉｍｕｍ ｌｅｎｇｔｈ呢？
v*r
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))
default maximum length in your external table/columns declaration, like : <
column_name> CHAR (1000))
c*t
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))
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
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
).
可能 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
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
: ).
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
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.
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.
相关阅读
About parameter query in MS Accessoracle forget password/username为什么有的电脑最基本的function都没有About data mining program如何向ORDB迁移关系数据库的数据。（Oracle）how to get rid of the inquiry windowHow to edit last sql statement in isqlRe: How to find a duplicate record in AcMSDE & VS.NET[转载] 旋转完成?Re: Cannot update records in JDBC???????请教数据库比较问题How to write this SQL? Urgent!!![转载] how about setting up a board for 3s?在iPlanet里怎么自定义用户属性?谢谢，但是...Re: 急问MS ACCESS的问题oracle websites-welcome BuChong有没有Server Performance Tuning 的人才？[转载] 还是Oracle用得多呀, 哪里有入门教程?请推荐：数据库设计方面的书