Re: comp.databases.kerry.sainsbury and tbtape

> In article c0d@newsbf01.news.aol.com, inxutil@aol.com (Inxutil) writes: > >Here's a legitimate question: > > > >If the data base is fragmented as it sits physically on the disk, does > >the tbtape PROCESS unfragment the data as it is streamed to the > >tape? > > > >Or is it streamed block by block in its fragmented condition? > > > >Would streaming it back to the disk if it WAS unfragmented to the > >tape be refragmented if the extents were not big enough? > > > >Why would I ask? Cause maybe I'm gonna reformat the hard drive(s) > >and restore the data base and wonder if maybe the data will be > >restored in an UNfragmented form even if the extents are not up to > >par. ( Yes maybe I should recreate the db with new extents ... :- > ) And Bill Glidden replies:- > No defragmentation occurs. Tbtape copies page images from disk to tape. > Included with each page image is the page address, which translates to > a physical location on disk. So, after restoring from tbtape, your > chunkswill look exactly the same. > > If you want to resize your table extents, you should use > dbexport/dbimport. > Bill, Just a quick question for my education, and that of the world as well, If you are planning to restructure your partitions on disk is it possible to use tbtape to archive the data? The reason I ask is that the first stage of tbtape is to check system pages on disk against those on tape. If they are not the same the tbtape restore process aborts. So, the way I see it is that if the root dbspace is changed in size or location then it would probably entail reverting to a dbexported system. Also, what would happen if the archive called for a dbspace that was no longer existing. Malcolm Weallans Online Database Consultancy