Re: Physical sizing of tables
Robert Cunningham-Brown wrote:
>How can I reduce the physical size of a table having deleted a large number
>of records from that table? I am using Informix SE V5 & ISQL V4.10.
>
>Any help appreciated.
I think that you are going to have to unload the table to a delimited ascii
file, do a dbschema of the table and save it in a file, drop the table,
recreate the table, and load the data from your delimited ascii file. When
you recreate that table, make some reasonable guesses about the size of
your first extent and next extents, and modify your schema accordingly.
Randall Young
ryoung@bix.com