郁闷
今天恢复数据库是报错load from cell_int_id.unl delimiter '$' insert into cell_int_id;
40386 row(s) loaded.---------------这个地方又成功导回
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_5608) 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
要么是违反约束，要么是数据格式问题,不知道那错了
请各位大侠看看
补充一点
我把是想数据放到临时表中，然后insert到表中不会出错,回复 #1 bobofreebird 的帖子
额........这些数据都有比较明显的提示错误~请自行检查..对于字段不一致,请检查下你的数据里是不是有"$"这样的符号~
给自己回落个贴
关于恢复数据库的问题解决了,不过是另一种方式[就是重新建一个库,然后在向新库中导入数据 ]难道每次恢复的时候都要重新建一个新库?请大家看看
页:
[1]