Re: System Catalog Tables

One approach is to do dbexport. change the schema file to include alter table to change next extent size at the beginning of the file and do dbimport. Regards, Rafal Czerniawski. hhong@nova.umuc.edu (hth) wrote: >Hi, >Couple of my system catalog tables have more than 8 extents, and every time >I try to run tbcheck -ce I get the whole bunch of lines: > ISAM error: can not open file>after showing those system catalog tables that have more than 8 extents. >However, the databases themselves seem still running fine. >Now, my thought is that maybe the extent problem causes the error. So, I >think I need to re-org those table by alter the extents first and then >alter the indexes to cluster. I had no problem with altering the extent >size, but indexes Informix won't let me do it. > >So, is there a way to reorganize or alter the system catalog tables, or if >you know the cause of the error above, please tell me. > >Thanx in advance, > >Duc >hhong@nova.umd.edu >