Re: Correcting Next Extent problems.

} } >From: Jack Parker <uunet!hpbs2561.boi.hp.com!jparker> } >Subject: Correcting Next Extent problems. } >To: informix-list@rmy.emory.edu (Informix Users Net) } >Date: Mon, 22 Feb 93 10:16:04 MST } >X-Informix-List-Id: <list.1920> } > } >... On system catalogs. } > } >On one of our engines, syscolumns and systables have over 8 extents. Now this } >is going to be interesting - how can I drop and re-create a table that } >defines itself? } } You can't alter the system catalog -- error -511 ensues. You can however } alter the next extent size if you are sufficiently privileged. I can't } remember of the top of my head whether that means you have to be informix or } whether being the principal DBA (the one who created the database and has } priority 9 in sysusers) is sufficient. } } Syntax: ALTER TABLE Systables MODIFY NEXT SIZE 128; You could ALTER the INDEX to CLUSTER. Sometimes, if space is not fragmented, its a cheap way to combine extents. -- Naomi Walker (aka N7FSA) naomi@anasazi.com "I'm not bad, i'm just drawn that way." Jessica Rabbit