Re: MAXEXTENTS on Informix 7.3

Posted in 2006

akshaymadane@gmail.com — 6 Jan 2006 21:38:38 -0800 — source: Usenet: comp.databases.informix

THANKS for the help....the idea of detached indices is a good one.... akshaymadane@gmail.com wrote: > Well I know that informix doesn't allow a table to grow beyond > maxextents....and that the ideal solution is to drop the table and > rebuild it using bigger extents. However is it somehow possible to work > out a temporary solution by increasing the no of extents somewhere? can > the alter command do this? My problem is that the rebuild of the table > will take too long and I can't afford that big a downtime right now. > Can I somehow change the maxextents without the reconfiguration of the > table?