Re: table extents cleanup

Kevin Brand wrote: > These tools take a binary image of Informix pages and are smart enough > to consolidate multiple extents into one ( or two in some situations ) > upon restore ( when you re-load an un-loaded database ). This is actually a feature of OnLine itself. Any of the load commands will load into one extent, if there is low database activity else where. If OnLine allocates an extent adjacent to the previous it will NOT allocate a new extent, but rather expand the size of the existing one. Just thought I would mention that. Cheers, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | | |Email: marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+