Re: Deframenting a table too big for ALTER INDEX

On Thu, 2 Apr 1998, Joe Lumbley wrote: > In article <3523E962.21C6@bloomberg.com> you wrote: > <SNIP> > > : I'll contribute my dbcopy.ec utility. I've run up to 40 copies of it > : concurrently copying subsets of a table from one place to another. It > : is very fast (tends to be as fast as INSERT INTO ... SELECT ... for a > : single copy within the same server) and (which is not relevant here) > : can copy between databases and servers even with different logging > : modes! Jake you might try that instead of unloading/reloading. > > : Art S. Kagel > > Art, are you going to post dbcopy.ec? If not, could you e-mail me a copy? > Thanks, I'll post another set of utilities to the IIUG Repository early next week. I have a few new utilities, old utilities that I have updated recently to make them generally useful, and updates to utilities contained in my original posting (utils_ak). Announcement on C.D.I. to follow. Art S. Kagel, kagel@bloomberg.com