Offhand I'm not sure if this is the "correct" way, but you could create new tables in the correct tablespace as select * from the old tables, and then just drop the old tables. Then add whatever synonymns, permissions etc the appilcations need.