sqlldr时候Field in data file exceeds maximum length
来源:互联网 发布:算法流程图模板 编辑:程序博客网 时间:2024/05/21 19:45
测试部使用sqlldr入库的时候遇到一个奇怪的问题 ,明明字段长度是256,数据文件中的列长度也是256,却报Field in data file exceeds maximum length问题,后来试着将字段长度改成280\300\1300照样导不进去,觉得很奇怪
查询MOS找到了答案:
fix:Change controlfile to define column as CHAR ('length') SQL*Loader does not have the concept different character datatypes. Incoming character data is assumed to be type char with a default length of 255. Thus, if the character string in the source Data File is more than 255 characters you will receive this error.
原来sqlldr引擎在检验数据文件的时候,遇到字符类型的时候,默认不能超过255,超过了就报错,如果想load超过255的字符,需要在控制文件中指明:
adress char(256),
可以看出sqlldr引擎的数据校验只是基于规则的校验,不会考虑实际表字段,这可能也是基于性能的一个考虑
- sqlldr时候Field in data file exceeds maximum length
- SQLLDR错误Field in data file exceeds maximum length
- [转贴]【sqlldr】 “Field in data file exceeds maximum length ”解决办法
- 【sqlldr】 “Field in data file exceeds maximum length ”解决办法
- Field in data file exceeds maximum length
- oracle sqlldr 数据导入错误Field in data file exceeds maximum length解决
- sqlldr导入报错:field in data file exceeds maximum length
- oracle sqlldr 数据导入错误Field in data file exceeds maximum length解决
- sqlldr: ield in data file exceeds maximum length in sqlldr datafile.
- Length of LOB data (78862) to be replicated exceeds configured maximum 65536
- Spring Boot:The field file exceeds its maximum permitted size of 1048576 bytes.
- Spring Boot修改最大上传文件限制:The field file exceeds its maximum permitted size of 1048576 bytes.
- code in hex file exceeds flash limitations
- ORA-01144: File size (4224000 blocks) exceeds maximum of 4194303
- ORA-01144: File size (4224000 blocks) exceeds maximum of 4194303
- "The length of the string value exceeds the length configured in the mapping/parameter."}
- Spring Boot 批量上传: The field files exceeds its maximum permitted size of 1048576 bytes.
- Spring Boot 批量上传: The field files exceeds its maximum permitted size of 1048576 bytes.
- RingtoneManager——铃声设置相关
- PreparedStatement 查询大容量数据内存溢出解决 .
- 注册表增改删 设置IE主页
- 【Service】使用有道翻译API构建翻译服务
- 如何在osgi container之外调用osgi bundle的对象和方法
- sqlldr时候Field in data file exceeds maximum length
- ebook中的购物车
- svn检出的时候报 Unable to connect to a repository at URL错误
- 【构建Android缓存模块】(一)吐槽与原理分析
- Android 编程下 Touch 事件的分发和消费机制
- 编译Linphone-android补充说明
- 【学习记录】关于Pin Tools的学习记录
- 统计服务器AYSAUX使用空间过多的问题
- 【构建Android缓存模块】(二)Memory Cache & File Cache