Re: Calculate Index Size problems

"Jay" <remove:jay@td.ca> wrote in message news:AdDPa.9770$ru2.1056797@news20.bellglobal.com... > > The reason why I am trying to calculate the index size is because one of our > production servers has serious extent interleaving. I am planning to unload > / load all databases within the instance, and include extent sizing. I need > to know how much disk space to expect after the extent allocation. Becuase > these databases have never been rebuilt, I expect there will be space to be > reclaimed after the unload / load. I just want to know how much space will > be reclaimed (becuase of the unload / load) or additional space to be taken > up after the NEXT EXTENT kicks in (since I only have 6 gigs left). > unload the table to a text file and rebuild it on a test server. Then you get the exact size. > >