I have a huge datapump export that I am copying from production to development. In it are 120 schemas that i need to transpose into multiple copies, ie fromuser a touser a1,a2,etc.
The new users can be created prior to running the import, but I have this additional problem: The production copy has 120 different tablespaces, one for each user, that the schemas' data is populated in.
How can i skip over the tablespace creates in impdp? in 9i, imp would dump the objects into the user's default tablespace if the specified tablespace didn't exist. is it the same behavior in 11g?
Also can I specify multiple targets in the fromuser/touser replacement, remap_schema?