- 论坛徽章:
- 0
|
本帖最后由 yankaga 于 2012-05-11 11:08 编辑
在执行INFORMIX9.4版本的创建索引脚本的时候报以下错误:
请各位大神协助,因为在INFORMIX板块还不能发帖,如果版主能帮我转去INFORMIX区那小子就多些了
Index created.
242: Could not open database table (gaps.ywty_msgfile).
113: ISAM error: the file is locked.
Error in line 2
Near character position 30
|
索引创建序列如下,第一个索引创建成功,第二报错误:
create unique index "gaps".msgfilesy1 on "gaps".ywty_msgfile (ywlx,
ptxym,xymxz) using btree in datadbs ;
create index "gaps".msgfilesy2 on "gaps".ywty_msgfile (ywlx,xymxz,
xym) using btree in datadbs ;
|
表结构如下:
{ TABLE "gaps".ywty_msgfile row size = 83 number of columns = 6 index size = 36 }
create table "gaps".ywty_msgfile
(
ywlx char(3)
default '' not null ,
ptxym char(9)
default '' not null ,
xymxz char(1)
default '' not null ,
xym char(9)
default '' not null ,
errtxt char(60)
default '' not null ,
jlzt char(1)
default '' not null
) extent size 32 next size 32 lock mode page;
revoke all on "gaps".ywty_msgfile from "public";
|
|
|