How badly do you want the space back? I believe you will indeed need to touch each row.
You could update each row with something like (update .... set column-1=column-1)
Good luck!
Barb
"Miller, Jay" <[EMAIL PROTECTED]> wrote:
But will this solve my problem in the near term? My understanding is that
simply changing the PCT USED won't move the problematic blocks off the
freelist until some sort of DML touches the block. Am I correct in this and
if so is there any way to resolve it?
Jay
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now
