Re: System Catalog Tables

hth (hhong@nova.umuc.edu) 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 Not a simple task. The best way to do is to dbexport and save the sql schema , and put the "alter next size" before the table creations. Another, unsupported way, is to create a table , let say syscolumns with the required extent size, copy from the original, and then swap the partnumbers noted on systables. After that you MUST SHUTDOWN you database without any other operation. This is a dangerous way, but is the faster one. You can do this for all catalogs tables except for systables. -- Renato Santis Applications Technical Support Oracle Chile e-mail:rsantis@cl.oracle.com voice:(562) 203-5353 ext 237 fax:(562) 203-5379 Av. El Bosque Norte 0440 Piso 15/16 Las Condes Santiago Chile