Move a schema from one tablespace to another

[sbasak1]

But man, I have almost 10,000 tables. I can't do it manually. Even if I do a PL/SQL function reading data from data dictionary, it would still too involving task.

I think ultimately I need to go for import/export anyway.