Re: Help: Reducing Extents

Chad I wrote a utility once that would do the modifications for you automatically. Not sure that I have a copy of it on my system anymore, but I might be able to get a copy sent to me if you are interested. The utility does the following: 1) Uses tbcheck/oncheck to determine the list of tables to unload. 2) Determines the size of the initial extent and next extent based on the amount of space taken up by the existing data and a growth %age you specify in a config file. 3) Crudely checks that there is enough space in the dbspace for the new table (the dbspace is also configurable). 4) Generates a copy of the table definition using dbschema, or uses an sql file that you specify. 5) Unloads the data, recreates the table and then reloads the data using onload/load depending on how you setup the utility. Mark MarkDenham@aol.com (home) Denham.M@amstr.com (work)