- 论坛徽章:
- 0
|
环境：
A机：SUN E5000
SOLARIS 5。8
Informix Dynamic Server Version 7.31.UD1
B机：PC SERVER
REDHAT7。2
Informix Dynamic Server 2000 Version 9.21.UC3
A，B两台机器上都有同一个数据库datebase,只是A上有数据，B上的库是空的，但结构和A机上的datebase一模一样（用dbschema和dbaccess生成的）。
A的datebase上有一表tableA，里面大概有30万条数据。我想倒到B机的tableB上。用的是SQL load 和unload指令。在A上运行
unload to "/tmp/file04" select * from tableA
得到文件file04，用FTP传到B机/tmp上，运行
load from /tmp/file04 insert into tableB
结果错误出现：
458：Long transaction aborted
847: Errors in load file line 12103(每次运行行号都不一样。)
我查过错误码：
-847 Error in load file line number
A problem exists with the data on the indicated line of the load data file. The operation stopped after it inserted lines up to but not including the line that is noted (number-1 rows have been inserted). If this operation is inside a transaction, roll back the transaction. If not, either delete the inserted rows from the table or remove the used lines from the file before you repeat the operation. To correct the file, look for additional error messages that might help isolate the problem. Possibly not enough, or too many, fields (delimiters) exist on the indicated line. Possibly a data conversion problem exists, (for example, nonnumeric characters in a numeric field, an improperly formatted DATETIME value, or a character string that is too long). Possibly a null (zero-length) field exists in a column where nulls are not allowed. Edit the load file to correct the problem. Look for similar problems in following lines, and then repeat the operation.
可能是上述几种错误，但我怎么改？如果删除出错的那一行，可每次出错的行号都不一样。错误依旧。
错误码描述中The operation stopped after it inserted lines up to but not including the line that is noted (number-1 rows have been inserted). 这句看不太明白（不好意思，英语太菜）。
请高手指定。极其迷茫当中。。。。。。。在线等待！ |
|
免费注册
发表于 2003-06-07 17:53
发表于 2003-06-08 20:35
