将一个DMP文件导入到数据库出现下面的错误：

显示全部楼层 · 2005-10-30 17:05:33

IMP-00019: row rejected due to ORACLE error 1401
IMP-00003: ORACLE error 1401 encountered
ORA-01401: inserted value too large for column
系统中原来没有某个表，将DMP导入时应该不会出现错误吧？

千问 · 2005-10-30 17:05:33

执行imp bgfa/bgfa file=f:\xing20060222.dmp fromuser=bgfa touser=bgfa tables=bd_nbzy log=f:\tw.log出错信息为：
. . importing table
"BD_NBZY"
IMP-00019: row rejected due to ORACLE error 1401
IMP-00003: ORACLE error 1401 encountered
ORA-01401: inserted value too large for column
Column 1 159700087
Column 2 159700080
Column 3 410014087
Column 4 36042719440800009
Column 5 查中礼
Column 6 2
Column 7 1
Column 8 200007
Column 9 242
Column 10 0
Column 11 200007
Column 12 2
Column 13 内部转移
0 rows imported
导入后表的结构为：
SQL> desc bd_nbzy;
Name
Null?Type
----------------------------------------- -------- ----------------------------
NB_ZCQYDM
NUMBER(9)
NB_ZRQYDM
NUMBER(9)
NB_FZH
NOT NULL NUMBER(9)
NB_SHBZH
VARCHAR2(18)
NB_XM
VARCHAR2(10)
NB_BRSFM
NUMBER(2)
NB_YGXSM
NUMBER(2)
NB_ZYNY
NUMBER(6)
NB_ZGGZ
NUMBER(7,2)
NB_JFJS
NUMBER(7,2)
NB_CLNY
NOT NULL NUMBER(6)
FLAG
NUMBER(1)
NB_BDYYMC
VARCHAR2(10)