`
GhostWolf
  • 浏览: 312767 次
  • 性别: Icon_minigender_1
  • 来自: 广州
社区版块
存档分类
最新评论

oracle sqlload error "Field in data file exceeds maximum length"

 
阅读更多
 

Symptoms

Loading long columns using sqlldr,the following error is reported:

" Record 1: Rejected - Error on table CRM_ATIC_HEADER_DIF, column LONG_DESC.
Field in data file exceeds maximum length "

Cause

In the control file,char(n) had to be specified for all the "varchar2" and "long" columns that were there in the table definition
分享到：
| jstack用法
评论
发表评论

您还没有登录,请您登录后再发表评论

相关推荐

    Input exceeds maximum length(解决方案).md

    Input exceeds maximum length(解决方案).md

    File size exceeds maximum limit of X KB(解决方案).md

    File size exceeds maximum limit of X KB(解决方案).md

    File size exceeds the maximum allowed limit(解决方案).md

    File size exceeds the maximum allowed limit(解决方案).md

    this exceeds GitHub's file size limit of 100.00 MB

    标题 "this exceeds GitHub's file size limit of 100.00 MB" 提醒我们，当单个文件超过 100MB 时，GitHub 将无法接受这样的提交。描述中提供了几种应对策略，这里我们将详细讨论这些方法。 首先，Git Large File ...

    oracle：Heap size 3597K exceeds notification threshold

    ### Oracle：“Heap size 3597K exceeds notification threshold” 解决方案 #### 背景与问题描述 在Oracle数据库环境中，可能会遇到一条警告信息：“Heap size 3597K exceeds notification threshold”。这条消息...

    STM8在线更新程序，IAP

    STM8在线更新程序，也称为In-Application Programming (IAP)，是STM8微控制器中实现固件升级的一种重要技术。这种技术允许用户在不借助外部编程设备的情况下，通过已有的程序来更新MCU中的应用程序代码。本文将详细...

    3D打印源码

    《3D打印源码解析与应用》 3D打印，又称增材制造，是一种通过逐层堆积材料来创建三维实体的技术。近年来，3D打印在制造业、医疗、艺术设计等领域得到了广泛应用，其开源文化更是推动了技术的快速发展。...

    OCI Programmer's Guide

    The INTEGER data type converts numbers.... If the number to be returned exceeds the capacity of a signed integer for the system, Oracle Database returns an "overflow on conversion" error.

    Edge Length Exceeds Limit(解决方案).md

    Edge Length Exceeds Limit(解决方案).md

    解决File size limit exceeded 错误的方法

    在编程过程中，我们有时会遇到“File size limit exceeded”这样的错误，这通常意味着我们的程序尝试创建或操作的文件大小超过了操作系统或特定软件允许的最大限制。在本文中，我们将深入探讨这个问题，以及如何解决...

    阿里微服务事务seata

    项目运行需要加入配置文件有:file.conf、registry.conf 在application.xml中引入： Spring: cloud: alibaba: seata: tx-service-group: my_tx_group 同时数据库驱动方式需要修改： <!--seata事务管理--> ...

    Predict whether income exceeds $50K/yr based on census data. Als

    https://archive.ics.uci.edu/ml/datasets/Adult Abstract: Predict whether income exceeds $50K/yr based on census data. Also known as "Census Income" dataset. Labels : >50K, age: continuous. ...

    Delphi7.1 Update

    Delphi 7.1 Update Release Notes=======================================================This file contains important supplemental and late-breakinginformation that may not appear in the main ...

    plsqldev12.0.3.1821x64主程序+ v12中文包+keygen

    Loading a text file in the Large Data Editor did not always process the encoding correctly Command Window would display empty lines when feedback is "off" Warning added when xls export exceeds the 64K...

    Control_maximum_number_of_rows_in_a_table.zip

    标题"Control_maximum_number_of_rows_in_a_table.zip"提示我们关注如何限制表中记录的数量。描述中提到的情况是特定场景的应用，即可能希望对特定业务规则进行限制，比如每个订单的订单行数不超过三个。 首先，...

    微软内部资料-SQL性能优化2

    The Windows 2000 cache manager provides data caching for both local and network file system drivers. By caching virtual blocks, the cache manager can reduce disk I/O and provide intelligent read ahead...

    微软内部资料-SQL性能优化3

    An intent lock indicates that SQL Server wants to acquire a shared (S) lock or exclusive (X) lock on some of the resources lower down in the hierarchy. For example, a shared intent lock placed at the ...

    oracle错误代码大全

    ### Oracle 错误代码解析 #### ORA-00001: Unique constraint violated - **解释**: 当尝试插入或更新的数据违反了唯一性约束时触发此错误。 - **解决方案**: 检查数据是否重复，并确保每个字段值都是唯一的。 ##...

    turbopascal编译错误和运行错误信息中英文对照表

    8. error 8: String constant exceeds line - 字符串常量超过一行 字符串常量过长，超出了单行的限制。 10. error 10: Unexpected end of file - 文件非正常结束 源代码文件在预期的终止位置之前就结束了。 11. ...

Magicbox
Global site tag (gtag.js) - Google Analytics