Re: Alter Fragment ... init ...

Because of a concept call extent concatenation. If the database can add a second extent physically next to the first one, it concatenates the two, and just ends up with one, bigger extent. Vic Kenneth Ma wrote: > Hi all: > > After I realized there is a table with too many extents (32), I did the > followings: > 1) increase the next extent size > 2)use 'alter fragment ... init ...' command to reorg this table > > Everything looks fine except the output from 'oncheck -pT' command: > number of extents: 1 > first extent size: 128 > next extent size: 1024 > number of pages allocated: 6272 > > How come there is only 1 extent, but the number of pages allocated is > 6272? > > Thanks for your help in advance !!!!!!! > > Kenneth ma -- Vic Goldberg Manager, DBA Team, Acting Manager, Technical Integration Cornell University (607) 254-7441 (Voice) (607) 255-6982 (Fax)