Forum OpenACS Q&A: Re: Reclaiming space used by Oracle LOBs
What I remember from the last time I had to deal with this (a couple of years ago) is that although you can resize a datafile it doesn't work on a LOB segment, so the only way to do it is to recreate the table via one of the methods mentioned. I was hoping that I was remembering wrong, that it wasn't going to be quite this messy, but it sounds like I am unfortunately correct.
This table has lots of foreign key constraints; I"m not sure how well that will work with move, select into, etc. We can try it, but I'm not too worried about using exp and imp either. Maybe I've just been lucky but they've always worked well for me.
If anyone has any good shortcuts please post; otherwise I will get out my hip boots and prepare to wade into the muck. :) Thanks!