免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 1233 | 回复: 0
打印 上一主题 下一主题

装库时出错,ORA_01400在线等 [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2004-04-02 09:51 |只看该作者 |倒序浏览
I was importing export dump file into a database. I got the following
>; >;>; error
>; >;>;
>; >;>; . . importing table "SPNLCNTRLDATA"
>; >;>; IMP-00019: row rejected due to ORACLE error 1400
>; >;>; IMP-00003: ORACLE error 1400 encountered
>; >;>; ORA-01400: cannot insert NULL into
>; >;>; ("SYSADM"."SPNLCNTRLDATA"."THDGROWACTBTNS"
>; >;>; Column 1 SAS_PROJ_AMORT
>; >;>; Column 2 ENG
>; >;>; Column 3 11
>; >;>; Column 4 O
>; >;>; Column 5 X
>; >;>; Column 6
>; >;>; Column 7 3
>; >;>; Column 8 X
>; >;>; Column 9 3
>; >;>; Column 10
>; >;>; Column 11 0
>; >;>; Column 12 O
>; >;>; Column 13 O
>; >;>; Column 14 O
>; >;>; Column 15
>; >;>; Column 16 O
>; >;>; Column 17 1
>; >;>; Column 18 O
>; >;>; Column 19 3
>; >;>; Column 20 0
>; >;>; Column 21 0
>; >;>; Column 22 0
>; >;>; Column 23 0 5870 rows imported
>; >;>; . . importing table "SPNLDEFN" 9602 rows
>; >;>; imported
>; >;>;
>; >;>; I checked out in the database where dump was taken for this particular
>; >;>; record there is nothing null. There exists some value but, the error
>; >;>; appears as if there was no value for some of the columns. What could be
>; >;>; the problem?
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP