当初建时表initial和next写得过小，导致扩展块太多。
如何修改initial和next，使扩展块不致很多。

一下子想不出聪明的办法，笨的办法有一个，
use rename command rename your current table.
create a new table with your old table name with properly parameter.  then use insert into as select ...  copy your data to new table, drop the old table.

In th first,export the table data.
truncate table
alter table
import the table ignore=y

you cannot change initial size by alter table command.

use ur schema manager, locater to the target table,and in it's properties ,u can choice the storage and there u can change the next property.but the initial property can not be changed.in fact it don't  influence  ur use.

change the next and pctincrease value for the future extent allocate

exp/imp

QUOTE:

---

最初由 zp8 发布
In th first,export the table data.
truncate table
alter table
import the table ignore=y

---

why "alter table",not drop table and recreate table?