I have a table that uses smart blob that I need to reorganize. We've
trimmed out about 2/3 of the data, so now I want to reclaim some of the
chunks from the sbspace, but the data is nicely fragmented all over the
place. What's the best way to do this? I don't have a whole lot of disk
space to play around with (since the table's about 50GB), so it would be
really nice if I could unload it to tape and reload it. I can't seem to
work out how to do that with smart blobs, though. Onunload doesn't work,
and the high-performance loader doesn't seem to work with in-line data.
The documentation isn't totally clear to me, but I've tried what it says
and I'm not sure what it's doing except that it isn't putting the blob
field in the output file.

The only way I've found that actually works is to use "unload to..." or
the HPL with a delimited format. This will create a series of 2GB files
with the binary data in it, which works great until I run out of space,
and it won't write those files to tape (so far as I've been able to
tell).

Any ideas?

Thanks.



DC