扩大表空间
表名:ZF_JSZZ_HIS ZF_JSZZ_HIS_BAK
create BUFFERPOOL BUF3 immedlate size 250
NUMBLOCKPAGES 108 BLOCKSIZE 32 PAGESIZE 32K;
create large TABLESPACE TS3 PAGESIZE 32K
MANAGED by AUTOMATIC STORAGE BUFFERPOOL BUF3 no file SYSTEM CACHING;
rename table ZF_JSZZ_HIS to ZF_JSZZ_HIS_BAK;
CREATE TABLE ZF_JSZZ_HIS (ZFMSGID VARCHAR(16) not null, TXID VARCHAR(35) not null, **constraint PK_ZF_JSZZ PRIMARY KEY ** (ZFMSGID)) IN TS3;
**insert into ** ZF_JSZZ_HIS **SELECT * FROM ** ZF_JSZZ_HIS_BAK;
表空间不够解决方案
最新推荐文章于 2024-04-28 21:46:33 发布