Re: Not able to increase the extent size?

calyanram@hotmail.com wrote: > I am not able to increase the extent size , next size beyond a > particular > level even if specify more number > > what to do? > example > create table test (with 200 columns ) extent size 3902 next size> 1858692 > > > what to check? > Actual size of contiguous extents is also limited by the available contiguous space in the dbspace(s) and the size of your chunks. You cannot get a contiguous extent larger than the size of the largest completely free chunk in each dbspace. You cannot get a contiguous extent larger than the largest block of contiguous free space in the dbspace(s). Art S. Kagel