数据库是11.50FC6,一个大表要重建,我使用的是外部表先将数据卸出,再装入:
CREATE EXTERNAL TABLE ffhz1_ext SAMEAS ffhz1
USING
(DATAFILES(
"DISK:/tmp/ffhz1_ext1.unl",
"DISK:/tmp/ffhz1_ext2.unl",
"DISK:/tmp/ffhz1_ext3.unl"
),
FORMAT informix, express
);
set isolation dirty read;
set environment IFX_BATCHEDREAD_TABLE '1';
INSERT INTO ffhz1_ext SELECT * FROM ffhz1_bak ;
Alter table ffhz1 type (raw);
INSERT INTO ffhz1 SELECT * FROM ffhz1_ext;
速度倒是很快,就是装入后建索引失败,错误号-105
有两个大表都这样。
对装完数的表做chechk报错:
TBLspace data check for easydb:easycon.ffhz1
Table fragment partition datadbs3 in DBspace datadbs3
WARNING: data page 0x42568 in tablespace 0xe00002 appears to be
more or less full than is indicated in the bitmap.
Bitmap mode: 0xc, Calculated mode: 0x4.
Reset the bitmap mode for this page?
请各位帮忙。
测试数据:
使用2个.sql建两个表,将数据装入ffhz1_bak,执行test.sh,完成后test_tab表建索引失败
附件:
a.part01.rar (7.11 MB)
a.part02.rar (5.49 MB)
收起