Re: initial extent is LESS THAN first extent size :WHY??

Posted in 1998

jeffso@lucent.com — Fri, 01 May 1998 09:14:49 -0400 — source: Informix-list mailing list archive (1991-1998)

So, similar question, if I have a large table over 5G, somehow, I delete some of the records and make it about 3G. Now, if I issue an ALTER INDEX TO CLUSTER on this table, what will happen? Will this operation be successful? Since there is no chunk can be bigger than 2G and I am now trying to get a continuous spaces for 3G. Thanks. Pete Smith wrote: > > > If Informix cannot allocate an extent of the specified size it will used the largest > available contiguous space - in this case 2Gb and likewise for the next extent. -- Jeff So Office : 973-3868839 Email : jeffso@lucent.com