how to find/set the parameter in DBMS_DATAPUMP as REMAP_SCHEMA in impdp

Posted on 2009-04-15
Medium Priority
Last Modified: 2013-12-18
in impdp, I can import a table to different schema as REMAP_SCHEMA=A:B from schema A to B, but is there any equalvent statement in DBMS_DATAPUMP, which I will do the same as impdp?
Question by:jl66
  • 2
  • 2

Author Comment

ID: 24154265
I just couldn't find this one.
LVL 22

Accepted Solution

Ivo Stoykov earned 1200 total points
ID: 24155376
you could use 
name parameter should be REMAP_SCHEMA.
Any schema object in the job that matches the object_type parameter and was 
located in the old_value schema will be moved to the value schema.
Privileged users can perform unrestricted schema remaps.
Nonprivileged users can perform schema remaps only if their schema is the target schema of the remap.
For example, SCOTT can remap his BLAKE's objects to SCOTT, but SCOTT cannot remap SCOTT's objects to BLAKE.


Ivo Stoykov

   handle      IN NUMBER,
   name        IN VARCHAR2,
   old_value   IN VARCHAR2,
   value       IN VARCHAR2,
   object_type IN VARCHAR2 DEFAULT NULL);

Open in new window

LVL 15

Assisted Solution

ishando earned 800 total points
ID: 24155379
LVL 22

Expert Comment

by:Ivo Stoykov
ID: 24156040
Perhaps I've missed something... isn't it what are you looking for?

"The METADATA_REMAP procedure is only supported for Import and SQL_FILE
operations. It enables you to apply commonly desired, predefined remappings to
the definition of objects as part of the transfer. If you need remaps that are not
supported within this procedure, you should do a preliminary SQL_FILE
operation to produce a SQL script corresponding to the dump file set. By editing
the DDL directly and then executing it, you can produce any remappings that you

LVL 15

Expert Comment

ID: 24156127
ivostoykov: Sorry if I caused confusion.
My comment was asking jl66 if the METADATA_REMAP procedure would suit.
I must have been typing while you were posting.

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses
Course of the Month16 days, 21 hours left to enroll

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question