建表时出现的问题 求助～
建表时出现如下错误信息～请高手帮帮忙～msg--| SQL0284NThe table was not created because the table space "YY_LONG" following the clause "LONG IN" is a "REGULAR" table space.SQLSTATE=42838
|
stm_text--|CREATE TABLE wj_seal(bno CHAR(24) NOT NULL,sealstat SMALLINT NOT NULL,bnotype VARCHAR(8) NOT NULL,usenum SMALLINT NOT NULL,lost_flag SMALLINT NOT NULL,td_flag SMALLINT NOT NULL,td_level SMALLINT NOT NULL,ice_flag SMALLINT NOT NULL,test_flag SMALLINT NOT NULL,conphone VARCHAR(16) NOT NULL DEFAULT '',phone1 VARCHAR(16) NOT NULL DEFAULT '',phone2 VARCHAR(16) NOT NULL DEFAULT '',conperson VARCHAR(32) NOT NULL DEFAULT '',personunit VARCHAR(128) NOT NULL DEFAULT '',note VARCHAR(256) NOT NULL DEFAULT '',cardid VARCHAR(20) NOT NULL DEFAULT '',recorddate TIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMP,usedate TIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMP,stopdate TIMESTAMP,address VARCHAR(128) NOT NULL DEFAULT '',recordoper INTEGER,recordsite INTEGER,verifyoper INTEGER,verifysite INTEGER,codenum VARCHAR(8) NOT NULL DEFAULT '',cardnum VARCHAR(12) NOT NULL DEFAULT '',site INTEGER,usercode VARCHAR(8) NOT NULL DEFAULT '',bankcode VARCHAR(64) NOT NULL DEFAULT '',image BLOB(640K) NOT LOGGED COMPACT,PRIMARY KEY(bno,sealstat)) IN YY_DATA INDEX IN YY_IDX LONG IN YY_LONG|
sqlstate--|42838|
var_info--||
create table wj_seal error ----------- 20120301164707
create tables fail!
页:
[1]