Reclaiming Unused Space in Datafiles…

Most of the time I write about stuff I’m interested in, but occasionally I’m forced into writing something to prevent me answering the same question again and again. This is one of those moments and it’s been several years in the making. The last time I tried to muster up the enthusiasm was on a flight last year and I got so bored I fell asleep.

Well today I finally got round to putting it together, so next time I get asked something like,

“I’ve moved a table to a new tablespace, how do I free up the space in the original datafile?”

I can answer, read this:

If you already know the answer, please don’t read it. I don’t want to be responsible for you falling asleep at your desk and losing your job. 🙂