Dave, sorry for not being clearer on that - yes, we know exchange doesn't put it in a new tablespace, I was just thinking out loud that we might want to do that to then transport the new tablespace out as a backup (leaving the old one in case it has other partitions).

Good thoughts on all this - sounds like there is no one single perfect solution. Thanks all.