Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Sam.

Asked: March 14, 2017 - 12:34 pm UTC

Last updated: March 16, 2017 - 1:13 am UTC

Version: 11g

Viewed 1000+ times

You Asked

I have a requirement to export a full database using EXPDP and import only three schemas using remap_schemas to a different schema than the original. How can I achieve that?

and Chris said...

If you only need to import three schemas, why are you exporting the whole database? Why not just export those three?

Anyway, if you've got a full data pump export, use the schemas parameter to state which ones you want, then remap_schema to load them into a different schema:

impdp ... schemas=s1,s2,s3 remap_schema=s1:r1,s2:r2,s3:r3

Rating

  (5 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Sam Jacob, March 14, 2017 - 7:28 pm UTC

useless answer
Connor McDonald
March 15, 2017 - 2:33 am UTC

On other questions that you've asked before, we've requested

- clarification
- test cases
- output
- examples
- error codes

because you fail to provide then, even though it spelled out clearly in the "Guidelines for asking a question".

Looks like we have to repeat the advice for your reviews as well..... sigh

Sam Jacob, March 14, 2017 - 7:29 pm UTC

I found out the solution and did the export import using expdp/impdp

How Rude!

Ian, March 14, 2017 - 10:57 pm UTC

Chris's solution worked fine for me. How about explaining why it was "useless" and sharing your solution?
Connor McDonald
March 15, 2017 - 2:30 am UTC

Trust me, you don't see the half of it :-)

Guidelines and plus

Moris, March 15, 2017 - 6:32 am UTC

I've already said that Sam is to much paid for what he provides. By the way why doesn't asktom team set a blacklist? Sure it'll be evident to use different pseudo but yet such posts would certainty come from Sam.
Connor McDonald
March 16, 2017 - 1:13 am UTC

We do have a blacklist facility, but AskTom is community - we'll try our best to be welcoming to everyone, even if they dont want to reciprocate.

Sam Jacob, March 15, 2017 - 1:26 pm UTC

Not useful. What is the problem if I am paid too much for what I do?

More to Explore

Data Pump

All of the database utilities including Data Pump are explained in the Utilities guide.