Re: Newby help, please - shrinking table size

Posted in 1998

John Carlson — Mon, 11 May 1998 17:56:16 GMT — source: Informix-list mailing list archive (1991-1998)

BJ Denenberg wrote: > > I noticed that, after purging our old call center records, the size of the > tables themselves did not decrease. I've seen this with Btrieve tables, as > well, but I have no idea how to remedy it with Informix databases. Can anyone > offer some assistance, please? Thanks, > > BJ Denenberg > > To respond via e-mail, remove "hatespam." from my address. You will need to unload the data, drop and recreate the table, then reload the data. John Carlson Informix DBA WH Smith, Inc.