一个怪异的现象:
xiapb 2003-01-14 11:10:29 在用EXP导出若干表的数据时一切正常, 但是在恢复数据时导入其中的几张表错误,其它的正常。
语法为:exp[imp] username/linkage file=filename tables=TD_NAME
错误信息如下:
Export file created by EXPORT:V09.00.01 via conventional path
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
. importing LINKAGE's objects into LINKAGE
. . importing table "TD_NAME"
IMP-00058: ORACLE error 1438 encountered
ORA-01438: value larger than specified precision allows for this column
IMP-00028: partial import of previous table rolled back: 26 rows rolled back
Import terminated successfully with warnings.
经检查,肯定不是数据约束、字段定义的原因。
郁闷....