Re: TBLSPACE table extents.

Hi, Once you have extents allocated you have few options available. dbexport/dbimport (if no options are specified) will put all tables into one extent. By the way there is no need for the re-initialize step. Also, note the -ss option of dbexport to retain extent sizes; this doesn't seem to be what you want now but once you get things configured properly it will be useful. The only other way I can think of to rebuild a table is to perform ALTER INDEX to CLUSTER on an index in the table you wish to rebuild.Be sure to run an ALTER TABLE tabname set NEXTSIZE=<new size> beforehand. I've never really tried this but have a hunch it might work. Hope this helps, Bill > > We are using OnLine 7.12 on HP900's running HP-UX 10.01 > > On each system the TBLSPACE tables have developed many extents > and been fragmented throughout the dbspace(s). I don't remember this > happening the same on version 5 that we ran previously. > > The only method for recovery has been dbexport, re-initialise and then > rebuild (dbimport). > > Does anybody have an alternative suggestion or ideas on how to > prevent it happening ? > > TIA > > Paul > > --------------------------------------------------------------------------------- > Paul Daniells paul.daniels@lovellwhitedurrant.com > Lovell White Durrant > London, England > > -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison email: ennis@ssax.com