你是如何导入到8I当中去的呢?
是用覆盖方式呢还是追加方式呢?
如果是用覆盖方式,可能会没有这样的问题了吧。。我查了一下资料,这里有相关的说明,你自己看一下吧:http://dbforums.com/t727891.html
还有这里的说明:ORA-01401: inserted value too large for columnI handle exceptions in a PLSQL procedure by printing them to a table
and raising the error. This is the error message that is printed to
the table by "dbms_utility.format_error_stack". I would like to see
the column name that caused this exception. How can I do this?Oracle8i Release 8.1.7.1.1Any ideas?BB
Da Morgan
Feb 5 2003 19:43 SVS wrote: > ORA-01401: inserted value too large for column
> I handle exceptions in a PLSQL procedure by printing them to a table
> and raising the error. This is the error message that is printed to
> the table by "dbms_utility.format_error_stack". I would like to see
> the column name that caused this exception. How can I do this?
> Oracle8i Release 8.1.7.1.1
> Any ideas?
> BBYou can't. Time to do a bit of detective work ... column by column ...
though you can likely ignore any DATE, CLOB, and/or BLOB.Sometimes this is caused by moving data that has "invisible" padding
with spaces such as a CHAR(3) into a VARCHAR2(2) when everything looks
like it is only 2 characters.If you post again ... include version and edition.Daniel Morgan
是用覆盖方式呢还是追加方式呢?
如果是用覆盖方式,可能会没有这样的问题了吧。。我查了一下资料,这里有相关的说明,你自己看一下吧:http://dbforums.com/t727891.html
还有这里的说明:ORA-01401: inserted value too large for columnI handle exceptions in a PLSQL procedure by printing them to a table
and raising the error. This is the error message that is printed to
the table by "dbms_utility.format_error_stack". I would like to see
the column name that caused this exception. How can I do this?Oracle8i Release 8.1.7.1.1Any ideas?BB
Da Morgan
Feb 5 2003 19:43 SVS wrote: > ORA-01401: inserted value too large for column
> I handle exceptions in a PLSQL procedure by printing them to a table
> and raising the error. This is the error message that is printed to
> the table by "dbms_utility.format_error_stack". I would like to see
> the column name that caused this exception. How can I do this?
> Oracle8i Release 8.1.7.1.1
> Any ideas?
> BBYou can't. Time to do a bit of detective work ... column by column ...
though you can likely ignore any DATE, CLOB, and/or BLOB.Sometimes this is caused by moving data that has "invisible" padding
with spaces such as a CHAR(3) into a VARCHAR2(2) when everything looks
like it is only 2 characters.If you post again ... include version and edition.Daniel Morgan
解决方案 »
- 问个SQL,高手进
- 创建无大小限制的表空间
- 两oracle服务器,A访问B的问题
- oracle日期类型插入数据库报错
- 请问open cusor 中有大量的table_4_2000_7727_0_0_0 这样的东西
- 请教有关如何统计每天订单数量的sql。
- 出来了,不在做开发了,现在在做ORACLE销售,需要大家帮忙啊,来者有分
- @@@怎样在ASP中用OLEDB连接ORACLE(最好不用DSN数据源)?
- Jdeveloper为什么连接oracle9i,连不上?有人确信能连接也给分,遇到过同样问题的也给分,最好能够解决问题。
- 数据库排序问题
- subtype怎么用,是不是可以来定义一个新类型保存到数据库后,可以用这类型建我的业务表?
- 高手请进
如果两个数据库都在,建议取出建表脚本比较,应该是这样的