load from cell_int_id2.unl delimiter '$' insert into cell_int_id2;
0 row(s) loaded.
load from radio_cell_g_bak2.unl delimiter '$' insert into radio_cell_g_bak2;
268: Unique constraint (informix.u1008_5526) violated. 100: ISAM error: duplicate value for a record with unique key.
847: Error in load file line 1.--------------------------这里失败
Error in line 908
Near character position 75
load from omc_h.unl delimiter '$' insert into omc_h;
846: Number of values in load file is not equal to number of columns.
847: Error in load file line 1..--------------------------这里失败
Error in line 909
Near character position 51
load from obj.unl delimiter '$' insert into obj;
16487 row(s) loaded.
load from switch_msc_copy331.unl delimiter '$' insert into switch_msc_copy331;
268: Unique constraint (informix.u1032_560 violated. 100: ISAM error: duplicate value for a record with unique key.
847: Error in load file line 1..--------------------------这里失败
Error in line 911
Near character position 77
load from project_log.unl delimiter '$' insert into project_log;
0 row(s) loaded.
load from emergency.unl delimiter '$' insert into emergency;
846: Number of values in load file is not equal to number of columns.
847: Error in load file line 1...--------------------------这里失败
Error in line 898
Near character position 59
要么是违反约束,要么是数据格式问题,不知道那错了
请各位大侠看看作者: bobofreebird 时间: 2008-04-08 21:25 标题: 补充一点 我把是想数据放到临时表中,然后insert到表中不会出错,作者: liaosnet 时间: 2008-04-09 09:38 标题: 回复 #1 bobofreebird 的帖子 额........这些数据都有比较明显的提示错误~请自行检查..
对于字段不一致,请检查下你的数据里是不是有"$"这样的符号~作者: bobofreebird 时间: 2008-04-10 14:07 标题: 给自己回落个贴 关于恢复数据库的问题解决了,不过是另一种方式[ 就是重新建一个库,然后在向新库中导入数据 ]