Datapump Import without creating tablespaces

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?
ie remap_schema=usera:usera1,usera:usera2,userb:userb1,userb:userb2
STLOracleDudeAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

sdstuberCommented:
you can use remap_tablespace  similar to remap_schema
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
STLOracleDudeAuthor Commented:
is there a way to globally remap all the tablespaces during the impdp?  The generated sql from the dump file is over 20 million lines long and I'm sure I could miss one or two referenced tablespaces.
0
sdstuberCommented:
no, sorry, I'm afraid there is no wildcarding for the remap operation.

You could generate the remapping though from either db by selecting from dba_tablespaces to maybe save some typing and put them all in your parfile.
0
STLOracleDudeAuthor Commented:
Can i dump all the remaps into a parfile? typing them all out netted 15k characters, well above the buffer for a single bash command.
0
sdstuberCommented:
yes
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.