Re: Reducing size of .dat and .idx in SE5.02

Posted in 1996

Richard Spitz — 5 Mar 1996 08:21:08 GMT — source: Informix-list mailing list archive (1991-1998)

Jonathan Leffler (johnl@informix.com) wrote: : When you do either an ALTER TABLE or an ALTER INDEX which is not a no-op, : then the table is rebuilt in a new file, and it is assigned a new Tabid in : SysTables. ^^^^^^^^^^^^^^^^^^^^^^^^^^ Is there a way to make sure that the rebuilt table has the same tabid _AND_ (even more important) filename as the original table? We need that because we have a database which is used by C-ISAM and SE concurrently. The table filenames are hardcoded into the C-ISAM app, so the rebuild of the table must not change that. Is it safe to rename the new file back to its old name and change systables accordingly? I'm rather hesitant to fiddle with tablenames. Regards, Richard -- +----------------------------+-------------------------------------------+ | Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | | EDV-Gruppe Anaesthesie | Tel : +49-89-7095-3413 | | Klinikum Grosshadern | FAX : +49-89-7095-8886 | | 81366 Munich, Germany | | +----------------------------+-------------------------------------------+