数据库有一个超大表,最近出现数据塞不进去,提示错误如下:
271:Could not insert new row into the table
136:ISAM error : no more extents
查数据库的存储分区及EXTENTS
oncheck -pt fin:ccc_file
TBLspace Report for fin:tiptop.ccc_file
Physical Address 96:492297
Creation date 04/04/2018 14:09:02
TBLspace Flags 802 Row Locking
TBLspace use 4 bit bit-maps
Maximum row size 843
Number of special columns 0
Number of keys 0
Number of extents 30
Current serial value 1
First extent size 16777215
Next extent size 7494144
Number of pages allocated 16777215
Number of pages used 16777215
Number of data pages 16284408
Number of rows 32568816
Partition partnum 10490140
Partition lockid 10490140
Extents
Logical Page Physical Page Size
0 81:3 999997
999997 236:3 999997
1999994 250:3 999997
2999991 270:3 999997
3999988 305:3 999997
4999985 318:3 999997
5999982 348:3 999997
6999979 349:3 999997
7999976 350:3 999997
8999973 83:3 936768
9936741 84:3 936768
10873509 226:11124 485052
11358561 207:417926 470384
11828945 218:113742 468384
12297329 221:428134 468384
12765713 134:251545 468384
13234097 342:149889 459724
13693821 204:3 267528
13961349 174:96998 259194
14220543 165:617691 250860
14471403 135:152245 234192
14705595 137:145202 234192
14939787 139:603387 234192
15173979 152:413655 234192
15408171 154:263999 234192
15642363 167:738170 234192
15876555 175:199296 234192
16110747 181:659653 234192
16344939 182:673394 234192
16579131 192:22211 198084
网上查了资料,说是page满了,不知道如何解决