Re: Correcting Next Extent problems.

Posted in 1993

Naomi Walker — Fri, 26 Feb 93 8:31:34 MST — source: Informix-list mailing list archive (1991-1998)

> > > > 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. Sorry, guys. I was wrong. You *cannot* do this on systables. It does work non-system tables. I typically try not to muck about with the system tables, and only do so when i've completely run out of ideas. I do not recommend playing with the system catalogs. -- Naomi Walker (aka N7FSA) naomi@anasazi.com "I'm not bad, i'm just drawn that way." Jessica Rabbit