AW: MAXEXTENTS on Informix 7.3

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