新人报道,不懂规矩,发帖求大神帮助-->INFORMIX
本帖最后由 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 btreein datadbs ;
create index "gaps".msgfilesy2 on "gaps".ywty_msgfile (ywlx,xymxz,
xym) using btreein 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";
雪地裸体跪求,坐等大神帮助
页:
[1]