I got this question from one of my clients. He is going to migrate one database from one platform to another. In this database many users are sharing the same tablespace.
In the current database, all application users are sharing the tablespaces “USERS”
The client wants to change this, so as each schema has its own tablespace. For example:
We all know that when using data pump import, we can use Remap_tablespace to map tablespaces. For example:
so, we can use multiple remap_tablespace options to map many tablespaces, but one source tablespace cannot be repeated. So, using remap_tablespace option will not fulfill our requirement.
Also, we have another option remap_schema to map from one schema to another, but unfortunately, we cannot use nested remap options like: remap_tablespace & remap_schema to remap based on two factors: Tablespace & schema. (This may be raised as enhancement request to Oracle).
So, how we can workaround this requirement?
I have two solutions in my mind, you may come up with another solution.
Donate to support our blogging work
Let us have a quick live demo about the proposed solutions: