SQLLDR错误Field in data file exceeds maximum length

创建表

create table objects(

owner varchar2(30),

object_name varchar2(50),

object_id number,

status varchar2(10),

created date);

控制文件

LOAD DATA
INFILE ldr_object.csv
TRUNCATE INTO TABLE OBJECTS
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
(owner,
object_name,
object_id,
created date 'yyyy-mm-dd hh24:mi:ss',
status )

加载以后提示 如标题所示错误

原来表中定义的字段 status 虽然是VARCHAR(10);

        但是用控制文件(CTL)中默认为是char类型。

        所以，当该列数据长度超过255（char类型长度）时会提示出错。

将数据文件和控制文件都改为 char类型即可