Drop indexes that are attached and recreate them detached.
as a temp solution (if you have attached indexes)

You may check with oncheck -pt <db>:<table>
If the indexes apareas as a separate parttion in the output they are
detached.

or : dbschema -d <db> -ss -t <table>


Best regards
Tilman



-----Ursprüngliche Nachricht-----
Von: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] Im Auftrag von akshaymadane@gmail.com
Gesendet: 05 January 2006 10:36
An: informix-list@iiug.org
Betreff: MAXEXTENTS on Informix 7.3

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?

_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list

No - you can't change the max number of extents for a structure. It's a
function of the partition page for that structure, and the room left on
slot 5 for the extent list.

Which version of 7.31 are you using?

Thanks -
Mark Scranton
IBM