- 论坛徽章:
- 0
|
dbimport 出錯!
原帖由 "大梦" 发表：
dbimport不会有表的错误！
你的那个信息看不懂！
我是在一臺主機用 dbexport 導出數據庫,然後在另一臺主机dbimport,我做過幾次總是在一個table那出這個問題,可我也檢查了這個table沒有問題,
http://bbs.chinaunix.net/forum/viewtopic.php?show_type=&p=3603329#3603329
出錯詳細如下:
{ TABLE "informix".tlf_file row size = 519 number of columns = 80 index size =
}
{ unload file name = tlf_f00576.unl number of rows = 1582823 }
create table "informix".tlf_file
(
tlf01 char(20),
tlf02 smallint,
tlf020 char(10),
tlf021 char(10),
tlf022 char(10),
tlf023 char(24),
tlf024 decimal(13,3),
tlf025 char(4),
tlf026 char(10),
tlf027 smallint,
tlf03 smallint,
tlf030 char(10),
tlf031 char(10),
tlf032 char(10),
tlf032 char(10),
tlf033 char(24),
tlf034 decimal(13,3),
tlf035 char(4),
tlf036 char(10),
tlf037 smallint,
tlf04 char(10),
tlf05 smallint,
tlf06 date,
tlf07 date,
tlf08 char( ,
tlf09 char(10),
tlf10 decimal(13,3),
tlf11 char(4),
tlf12 decimal(16,,
tlf13 char(,
tlf14 char(4),
tlf15 char(24),
tlf16 char(24),
tlf17 char(20),
tlf18 decimal(13,3),
tlf19 char(10),
tlf20 char(10),
tlf21 decimal(15,5),
tlf211 date,
tlf212 char(5),
tlf2131 smallint,
tlf2132 smallint,
tlf214 smallint,
tlf215 smallint,
tlf2151 smallint,
tlf216 smallint,
tlf2171 smallint,
tlf2172 smallint,
tlf219 smallint,
tlf218 smallint,
tlf220 smallint,
tlf221 smallint,
tlf222 smallint,
tlf2231 smallint,
tlf2232 smallint,
tlf224 smallint,
tlf225 smallint,
tlf2251 smallint,
tlf226 smallint,
tlf2271 smallint,
tlf2272 smallint,
tlf229 smallint,
tlf230 smallint,
tlf231 smallint,
tlf60 decimal(16,,
tlf61 char(4),
tlf62 char(10),
tlf63 integer,
tlf64 char(1),
tlf65 char(12),
tlf66 date,
tlf901 char(1),
tlf902 char(10),
tlf903 char(10),
tlf904 char(24),
tlf905 char(10),
tlf906 smallint,
tlf907 smallint,
tlf908 char(1),
tlf909 char(1),
tlf910 char(1),
primary key (tlf01,tlf07,tlf08,tlf09,tlf026,tlf027,tlf036,tlf037) constrai
"informix".ct_tlf_file2
);
*** 輸入資料已被毀損 !
0 - 不認識的錯誤訊息編號 0. |
|
免费注册
发表于 2005-05-11 17:48
发表于 2005-05-12 21:10
