re build a table with 53 extents

I have a package which created a table that had small extents when that package was installed. I really never looked at this table but now, two years later I find not only that the table exists but that it the 53 extents The table is in views and has constraints that I do not understand, Is there any way to reoganize the table to one 3 or the extents with out droping it? I have room in other dbspaces if that helps. The table is not very big but these extents are really slowing things down

It's unlikely that 53 extents is actually slowing access to the table significantly, but here's the answer: alter table next extent <new next size>; -- to increase the size of additionalextents. alter fragment on <tablename> init in <dbspace name or fragmentationexpression>; You can use the alter fragment to reorg into the same dbspace or a different one or to initiate a fragmentation scheme. Art S. Kagel ----- Original Message ----- From: Cwm@Stober.Com <ids@iiug.org> At: 2/18 19:13 I have a package which created a table that had small extents when that package was installed. I really never looked at this table but now, two years later I find not only that the table exists but that it the 53 extents The table is in views and has constraints that I do not understand, Is there any way to reoganize the table to one 3 or the extents with out droping it? I have room in other dbspaces if that helps. The table is not very big but these extents are really slowing things down ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.