Re: tbtape question

} } > } > At 09:53 PM 12/23/94 -0500, Borg Boy wrote: } > >Question: Will unloading a database using tbunload, then dropping it, and } > >loading it back in using tbload defrag the tables? } > > } Jon Vemo sez: } > NO. tbunload performs a binary unload of each page, page for page. Any } > fragmentation which existed before, will still be there after tbload'ing. } > } } I thought 'tbunload,drop,tbload' was one of the sanctioned methods for } defragging disc space. What does one use? } tbload/tbload does re-extent tables. What it doesn't do is shrink tables that have had many rows deleted. For that you have to unload/dbload the table. -- Naomi Walker (aka N7FSA) | naomi@anasazi.com | Phoenix, Arizona ----------------------------------------------------------------- Dyslexsics, Untie! | Visualize Whirled Peas