P
Paul Koufalis
Guest
How big is the rest of the stuff in Area B? It may be easier to just tablemove or D&L the rest of the stuff then truncate the area. My additional $0.02CAD: How much space do you expect to recoup? Is it worth the hassle? How long will it take you to fill up that BLOB space with new records? Usually the time/effort cost to recoup disk space is higher than the cost of the associated space. For the other DBAs listening in: will those newly emptied BLOB blocks show up as free blocks and not get backed up by probkup? I would think so but I'm not certain.
Continue reading...
Continue reading...