How to move an oracle user from one tablespace into another
we want to migrate a database from one server to another. It's a dev database.
To consolidate the structure we want to move several users with their tablespaces and datafiles all back into the tablespace users.
So a solution could either be to make these changes in the old (new) database or during the import with the oracle datapump.
Precisely I need help how to accomplish that task.