Re: ** Extent limit reached, please help !! **

1) How big was he last extent allocated? If you don't know look in systables at the field nextsize for the table in question. 2) How much space is free in this table? run oncheck -pT <database>:<table name> 3) If you don't have much space free can you afford to unload some of your data to a unl file (temporarily) then delete it from the table? This will allow you some space until you can recreae the table. Did you get some sort of warning from the engine that you're at the max extents? -Bill > > Online Version 5.07.UC1 > > We have a "large" (> 12Gb) table, it has reached it's maximum number of > extents and we can't add records. We could unload the data, recreate the > table with larger extents and reload, but we are a 24 hour operation and > this would take forever. > > Is there any quick fix we can apply, which would get us through the next > few weeks? > > Potential responders, please reply to my email address as well as the > Newsgroup. Thank You. > -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison email: ennis@ssax.com