Re: Help - I've hit the maximum number of extents in Informix 5

You need to find some downtime and diskspace. Unload the table to a file. Drop and recreate the tables with new sizing and extent sizing. Reload the table from a file. In a production world this usually means late nites and weekends. Oh and perform at LEAST one complete archive for Mr. Murphy before you start. (Two if you believe that Mr. Murphy has a relative that will eat your backup tape at the worst possible moment) (( As you can tell I have a true respect for Murphy's Law ;-) )) You can do the computations necessary for new sizes & extent sizes before hand. Read up on the section in the Online Admin Guide. Good Luck -- Rob Vorbroker Phone: 513/336-6741 Vorbroker Consulting, Inc. FAX: 513/336-6742 robv@vorbroker.com www.vorbroker.com Ray Russell <rlrussell@tasc.com> wrote in article <35116385.3817@tasc.com>... > Has anyone out there seen what happens when a table grows to the point > where it reaches the maximum number of extents. Can this cause > corruption in the dbspace, or just an error message? > > Ray Russell >